Link to home
Start Free TrialLog in
Avatar of Don-White
Don-WhiteFlag for United States of America

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?
 
ASKER CERTIFIED SOLUTION
Avatar of fjaf
fjaf

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial