Report on Combo Values

[sadozai]

Dear Experts!


I have a combo box on a form called "ISSUES" and the values are following;
1) Access Issue
2) Lack of awareness
3) Poverty

I have a table in which along with other columns, i have this combo "Issues" and another column of City. I want to group by my report on city column and count how many "Issues" are under every city. The report should look like this.

CITY "ACESS ISUE" "LACK OF AWARENESS" "POVERTY"

NY 120 20 10
LA 27 5 3

I understand it is a simple report for you guys but for a novice like me it will be great help from you.

Thanks

[Robeen]

I haven't worked a lot with Crosstab queries - but I created a real quick table with an 'ID' (AutoNumber) field, a 'City' field and a field named 'Issues'.

Then I went to 'Query Wizard' -> 'Crosstab Query Wizard' and it was real easy to create a query that looked exactly like what you are aiming for.

I hope this helps!