I have a cross tab query, which I got help under the REPORTS forum, but I need to better break out some data.
My column headers are Salesperson then JAN FEB MAR et.c
It is displaying number of cars sold per month per salesperson. but what I really need to see is number of USED and NEW per month per salesperson.
The code below works but only giving me the total NEW and USED for the year.
I'm close but can't get over the hump as far as how to re-write the SQL to do what I need.
Total New: Count(IIf([vehNewUsed]="New",0))
Total Used:Count(IIf([vehNewUsed]="Used",0))
Thanks for the nudge in the right direction.
My column headers are Salesperson then JAN FEB MAR et.c
It is displaying number of cars sold per month per salesperson. but what I really need to see is number of USED and NEW per month per salesperson.
The code below works but only giving me the total NEW and USED for the year.
I'm close but can't get over the hump as far as how to re-write the SQL to do what I need.
Total New: Count(IIf([vehNewUsed]="New",0))
Total Used:Count(IIf([vehNewUsed]="Used",0))
Thanks for the nudge in the right direction.
