Report to group by model numbers with a count per locaton

D

Darrel A

I need to create a report that has 40 columns. The first one is a list of
model numbers and the other 39 need to show a count (how many) at each of our
store locations based on the condition of a status of "N" (new). The table I
am pulling the data from has Model, Store nbr, Unique serial nbr, & Status.

Any suggestions would be great.

Thanks,
Darrel
 
D

Darrel A

No I haven't...Never did a crosstab query before. I'll start looking into it
but if you have any suggestions, they would be more than welcome.
 
D

Duane Hookom

Model, Store nbr, Unique serial nbr, & Status
You would use Model as the Row Heading, Store Nbr as the Column Heading, and
Count(Unique Serial Nbr) as the Value. Set a criteria of Status = "N".
 
D

Darrel A

Sounds easy enough...thanks

Duane Hookom said:
Model, Store nbr, Unique serial nbr, & Status
You would use Model as the Row Heading, Store Nbr as the Column Heading, and
Count(Unique Serial Nbr) as the Value. Set a criteria of Status = "N".
Click to expand...
 
Top