Help with a simple (?) count query

[rexnervous]

Have a single table with date, gender, age, county. Need to build a query/report(s) that does the following:

1. Need one that gives me # of males assigned to each date. So I can tell someone there were 12 males assigned to January 2nd, 2 males to January 3rd etc.

2. Need to do the same with age, but within certain age ranges. This I assume will be the same as above, but I'll just run a new query for each age range.

3. Now a little more complicated - I need to do the same with county, but there are multiple counties. So I'd need a table report that goes:
Date | County A | County B | etc
Jan 1st 12 4 etc.

I know how to build basic queries, but am having trouble with the count thingy, as well outputting to a report.

Thanks in advance.

 

[coyotem78]

I think this will work

1. If you creare a query with the following fields Gender, Date, Date. Then you "Group By" the first 2 fields and "Count" the last field. Then you just put the criteria "Male" on the first field. That should give you the number of males for each date.

2. You're right the same thing as 1.

3. If you do the same as 1, you should get what you need.

 

[SydneyGeek]

For putting the counties across the columns, you need to use a crosstab query. There's a wizard for building them. Using the Date-restricted query as a data source:
Put Gender into Row
Put County into Column
Put Name (or whatever) into Data, and select Count as the summary function.

To put this into a report, first check that the crosstab is OK and then run the Report wizard. Use the new crosstab query as the data source, and insert all fields. When you run the report you will be prompted for the dates, and all will be revealed.

Denis