• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

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?
1 Solution
you need to group by record type like:

select recordtype, count( recordtype)
from mytable
where mycondition
group by recordtype

Hope this helps!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now