Count total records from a query

  • Thread starter Thread starter Shane
  • Start date Start date
S

Shane

I have a query with 3 fields that have criteria's for
them and I need to return a value to a form that counts
the records that the query finds. Any help would be great.
Thank You
 
If all you need is a count, on your form you can use
DCount("[NameOfField]","NameOfQuery") as the record source for an unbound
text box.

Kelvin
 
Back
Top