> >
> > I'm so sorry, too. But i can't do that in VFP 6. :-D
> >
> > CriZ (,")
> >
> > "Everyone is entitled to their own opinion, but not their own facts."
>
>
> That's not the count for each combination of code1 and code2
> You can do this in VFP6 with the code Borisslav posted and with the code I posted.
> -Anders
We have different result.
> I would like to group the table on CODE1 and CODE2 counting the records within each group. I would then like to select the records with the
highest count in each group.
If you have a table structure like this...
Code1 Code2
1 3
1 4
2 2
3 4
3 1
3 1
Code1 has the highest count of 3 which are three 3's and Code2 has the high count of 2 which are 2 counts of 4's and 1's.
CriZ (,")
"Everyone is entitled to their own opinion, but not their own facts."