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

  • Thread starter Healthcare Executive
  • Start date
H

Healthcare Executive

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.
 
D

Duane Hookom

I think you can use a condition like:
DCount("*","YourQuery","Your condition expression") >0
 
Top