How to get more than one value/column heading in crosstab query

[bhaktharvali]

Dear all,


I am learning access through forums and google search only. Thanks to all, who contributed.
Now, I am in the process of generating queries.

I have a database and I want a summary table. I generated this successfully in excel. But, now I want to do this in access. Is it possible to have more than 1 (about 10) value fields or columns in crosstab query? Please guide me
Regards
Vali

[RayMilhon]

Not in a crosstab. However you may be able to do it in a regular query. by using a group by you can group on 1 or more fields and then do a count or sum of your value fields. If you post a sample of your required output I can be more specific

[bhaktharvali]

Mmmmmmmmmmm!!!!!!!!
Thank you so much,
I just got what I wanted, Reduced bundles and days of work to a single click in few seconds
Really thrilled!!!!!!!!
Vali

[RayMilhon]

Glad I could help.