Report to group by model numbers with a count per locaton

  • Thread starter Thread starter Guest
  • Start date Start date
G

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