get two field data row & column wise

eddii

Registered User.
Local time
Tomorrow, 04:06
Joined
Oct 10, 2011
Messages
55
i have a query which has two fields one is "months" and other is "status"

is it possible to get data column wise "months" ( jan,feb,mar....)

and row wise "status" ( good, better, best )


these are the months field items

months : jan feb mar apr may jun

goodsum: 10 5 3 12 16 11 ( sum means total number of good in jan month )
bettersum : 5 3 13 5 11 11
bestsum : 6 15 0 7 6 11

rowwise data is from status field

can any pls help
 
You want a crosstab query.

However I don't use them so that's the limit of my help! :P

Google it (or search this forum) or try the wizard.
 
So using a Crosstab query:

Column Heading - Months
Row Heading - Status
Value - Count of Status
 
thanks for the reply vbainet i got it working
 

Users who are viewing this thread

Back
Top Bottom