Don-White
asked on
Record count from query to menu form
Using Microsoft Access & VB
I need to put a count of certain type of records from a file on the opening menu.
Count such as:
Open - 123
Closed - 3
Archived - 12
The file has a total of 138 records, 123 open, 3 closed, and 12 Archived.
I did a query to count a field called Status and it does the correct count.
I cannot get the count for each of the type of records to print on the menu form.
How do I select the proper count from the query?
I need to put a count of certain type of records from a file on the opening menu.
Count such as:
Open - 123
Closed - 3
Archived - 12
The file has a total of 138 records, 123 open, 3 closed, and 12 Archived.
I did a query to count a field called Status and it does the correct count.
I cannot get the count for each of the type of records to print on the menu form.
How do I select the proper count from the query?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.