Query by quater in different columns for respective field parameters

[sunnyday]

Hi,
I am not that good in access. I need help. I need to create q1 q2 q3 q4 columns in a query and it calculates the count of those fields respectively. and does a grand total for a finacial year.



eg:
Market Veg Q1 Q2 Q3 Q4 where Q1 Q2 Q3 Q4 are quarters
A carrot
B potatoe
spinach
Count
Total
I have done the quarters by using the expression Qtr: "Q" & Format([Enter Date],"q-yyyy"). But then it shows everyrthing in 1 column. I would like to have seperate columns and which it will show out in a report as well
Thanks in advance

[June7]

Sounds like you need to do a CROSSTAB query. Building a stable report to run perpetually based on a CROSSTAB is not easy. Review: http://allenbrowne.com/ser-67.html

[sunnyday]

Thanks so much. Crosstab query seemed to work. and the qtr expressionis same , just adding in q-yyyy in cross tab worked fine .