Counting records with multible criteria?

[rick roberts]

i have a table that contains a selection of meats -- beef turkey etc and also their weight. i want to end up with a report that gives an order list containing the count of each meat at each different weight ie 12 turkeys @ 20kilo 15 turkeys @ 25kilo . i have considered using a combo box that contains a series of meats at different weights which would simplify the problem but i would prefer to use seperate boxes for meat and weight - can i create a report in this way? --if so - -how?

 

[Brianwarnock]

I think this is a simple totals query, groupby meat, group by weight, number:count(*) with expression selected in the Total field.

Brian

 

[rick roberts]

it works

thanks thats what i wanted - i guess it wasnt as difficult as i first thought