New to Access- help with counting rows

[cip315]

I have one main table of data. I used queries to separate the data into certain subsets based on their values. I now have 5 query tables, four of which are subsets of the fifth. I want to compare the amount of rows per table to get a percentage. Is that another Query? How would I go about getting this?

[NTC]

you can do it using a Report - and its grouping feature - - from a common record source

or you can do it - as you have started - via queries. You would need to do an AggregateQuery on your existing queries - that will return the record count; and then plug those values into a form/report.

[cip315]

I tried that by entering the expression Expr2: Sum(Count(*)) and it told me I couldn't do a AggregateQuery there. I have it working in a report where it will print the two queries next to each other but I was looking for something like:

value 1 ####
value 2 ####
value 3 ####
Total ####

[cip315]

http://www.techonthenet.com/sql/count.php

My table is up to example 3 here. I would like to add a lower row alloing a total, or even another column tracking the total.

[NTC]

it would appear that a standard report with group and sums set up will meet your need. if you do not know how to do this - you should get an Access text book in your version available at any big box book store or Amazon. these books all explain how to set up a Report with grouping and sums.... or you can play around - the wizard should help you step thru it when setting up a report.

[Xiaoding]

http://www.techonthenet.com/sql/count.php

My table is up to example 3 here. I would like to add a lower row alloing a total, or even another column tracking the total.

Getting the number form a report is tricky, didn't work for me.

You can use DCOUNT to return the number of rows in a query.

"DCount ( expression, domain, [criteria] )"

which means, "expression is the field that you use to count the number of records.
domain is the set of records. This can be a table or a query name.
criteria is optional. It is the WHERE clause to apply to the domain."

To use in a query,
Expr1: DCount("TAG_NU","pm's feb") so, field, query name.

Tag_NU is the filed use use to count, PM's Feb is the name of the query. It returns a column that gives you the count for each record in the set.

Which leads to a problem, if you try to total the record count, you get a huge number. I had 4 tables, which I also wanted to use the record numbers for, to get a count for each. I made an additional query, to get a record count from the other 4 querys, and set the unique value to 1 or yes, so that I got only one result per query, then used that for my report. Hope this helps!