How to count the number of results to a query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to count the results to a query in Microsoft Access. I have
several criteria from different fields, all from the one table. I would like
to find out how I can count all of the records that satisfy the criteria.
Finally, I need to find out what proportion of the records (currently 33325)
satisfy the criteria. Please consider that I have only high school knowledge
of Databases :-s.

Thanks,
Tom
 
Hi,


DCount("*", "tablename", "FieldName = 343 ")


returns the number of records where the value, under Fieldname, that are
equal to 343. If the constant is not numerical, use the appropriate
delimiter:

DCount( "*", "tablename", " City = 'Paris' AND State='Texas' " )


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top