sum number of rows in different queries?

[Kenneth]

How can I calculate number of rows in different queries?

I have one query for each day, and there is 365 days. Each query have a
different number of rows:
1st of January have 30 rows, 2nd of January have 59 rows, etc.

I want to sum the rumber of rows, like 30+59+ etc.
Is there an easy way to do it with Access??

-kenneth

[Keith Wilby]

"Kenneth" <sn*******@hotmail.com> wrote:

How can I calculate number of rows in different queries?

I have one query for each day, and there is 365 days. Each query have a
different number of rows:
1st of January have 30 rows, 2nd of January have 59 rows, etc.

I want to sum the rumber of rows, like 30+59+ etc.
Is there an easy way to do it with Access??

-kenneth

Hi Kenneth.

You need to invoke the "totals" utility in your query. This will show the
"totals" line in your query grid. Set the date field to "Group By" and the
primary key field to "Count".

Search the help on "totals" for more info.

HTH - Keith.

[Alan Webb]

Kenneth,
Jeeze, you are working too hard. SQL GROUP BY clauses will do this in one
SQL statement. You would group by date and use COUNT(*) AS ROW_COUNT to
count your rows. 365 seperate queries? My head hurts.

"Kenneth" <sn*******@hotmail.com> wrote in message
news:ca**********@dolly.uninett.no...

How can I calculate number of rows in different queries?

I have one query for each day, and there is 365 days. Each query have a
different number of rows:
1st of January have 30 rows, 2nd of January have 59 rows, etc.

I want to sum the rumber of rows, like 30+59+ etc.
Is there an easy way to do it with Access??

-kenneth