Queries

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am trying to count the number of records which meet a
certain criteria. Each record has a field which states
the number of items needed to be completed in a request.
As a part of the request gets completed a new record is
added. What is the best way to query the data to get a
result which calculates the number of records(i.e the
number of items completed in a request)?

Thanks,
John
 
Hi,



SELECT QuestID, COUNT(*)
FROM myTable
GROUP BY QuestID



Hoping it may help,
Vanderghast, Access MVP
 
I am trying to count the number of records which meet a
certain criteria. Each record has a field which states
the number of items needed to be completed in a request.
As a part of the request gets completed a new record is
added. What is the best way to query the data to get a
result which calculates the number of records(i.e the
number of items completed in a request)?

Thanks,
John
Click to expand...

A Totals query, created by clicking the Greek Sigma icon in query
design view.
 
Back
Top