How to report for 50 counties?

[MN]

Hi -- How can I report the county 1,2,..10,11,19 in the first quarter but in
the second quarter they have only county1, and 3 third Q. they have county
5,10,15,20 then 4th Q they have nothing. How can i design in the report?
Thank you for any reply.

 

[Duane Hookom]

You aren't giving us much to go on. We don't have a clue regarding your table
structures, data, or desired display in your report.

A vague question like this suggests your tables are not structured
correctly. I could be wrong but really can't tell anything from the
information you have provided.

 

[MN]

Sorry for missing that.
My tableA have clientID (PK) countycode (number field) entrydate (date field)
Ex:ClientID Countycode entrydate
0001 001 01/02/2009
0002 001 03/31/2009
.....
0900 050 05/02/2009
0901 002 10/01/2009
.....
The report will like this:
1st Quarter 2nd Quarter 3rdQuarter 4thQuarter Total
County01 2 0 0 0
2
County02 0 0 0 1
1
County50 0 1 0 0
1

Hope this clarify to you. Thank you

 

[Steve]

Would a crosstab report fit your bill? You could create a crosstab query
showing quarters as columns, counties as rows and values as whatever you are
wanting to show for each county in each quarter. Then use the crosstab query
as the recordsourceof your crosstab report.

Steve
(e-mail address removed)

 

[KARL DEWEY]

This will do it but remember this rolls all years together.

TRANSFORM Count(TableA.Countycode) AS CountOfCountycode
SELECT TableA.[Countycode]
FROM TableA
GROUP BY TableA.[Countycode]
PIVOT "Qtr " & Format([entrydate],"q");

 

[MN]

Thank you ... for your suggestion!

Would a crosstab report fit your bill? You could create a crosstab query
showing quarters as columns, counties as rows and values as whatever you are
wanting to show for each county in each quarter. Then use the crosstab query
as the recordsourceof your crosstab report.

Steve
(e-mail address removed)





.

 

[MN]

Thank you .
You are save my time .

Regards,
MN

This will do it but remember this rolls all years together.

TRANSFORM Count(TableA.Countycode) AS CountOfCountycode
SELECT TableA.[Countycode]
FROM TableA
GROUP BY TableA.[Countycode]
PIVOT "Qtr " & Format([entrydate],"q");

--
Build a little, test a little.

Sorry for missing that.
My tableA have clientID (PK) countycode (number field) entrydate (date field)
Ex:ClientID Countycode entrydate
0001 001 01/02/2009
0002 001 03/31/2009
.....
0900 050 05/02/2009
0901 002 10/01/2009
.....
The report will like this:
1st Quarter 2nd Quarter 3rdQuarter 4thQuarter Total
County01 2 0 0 0
2
County02 0 0 0 1
1
County50 0 1 0 0
1

Hope this clarify to you. Thank you

 

[Rachel Anne Alkire]

Hi -- How can I report the county 1,2,..10,11,19 in the first quarter but
in
the second quarter they have only county1, and 3 third Q. they have county
5,10,15,20 then 4th Q they have nothing. How can i design in the report?
Thank you for any reply.