Queries

[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

 

[Michel Walsh]

Hi,



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



Hoping it may help,
Vanderghast, Access MVP

 

[John Vinson]

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

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