Conditional count

[hklein]

Hi, I would like to make a query, which counts fields contanining a specific field. I have a table: ID;Person;state;city (value of the city can only be city1, city2 and city3) As a result I would like to have a report,which tells, - how much persons are the total in the each state - how much person are the in ecah state where the value of the citiy is city1 - how much person are the in ecah state where the value of the citiy is city2 Thank you

[June7]

Build a report using Grouping and Sorting with summary calcs. Access Help has guidelines or Google: Access report grouping

http://office.microsoft.com/en-us/ac...010006894.aspx

[hklein]

Thanks, although I expected a bit more concrete help

[June7]

Set up a group section on the city field. Have textbox in group footer count records, like: =Count(*).

Make attempt and will be happy to review when you encounter issues.

[hklein]

Many thanks