how to check whether a value exists within the results of a query

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

Guest

My query returns several records based on criteria I specified. I want to
build a Macro that is based on a condition that examines the results of the
query and sees whether a certain value is included in the query results (for
a certain field), so that if that value is included in the results, the Macro
performs a certain function.
 
I think you can use a condition like:
DCount("*","YourQuery","Your condition expression") >0
 
Back
Top