Report to group by model numbers with a count per locaton

[Guest]

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

 

[Duane Hookom]

This sounds like a crosstab query. Have you gotten that far yet?

 

[Guest]

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.

 

[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".

 

[Guest]

Sounds easy enough...thanks

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".