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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
Remove a result from a query 2
Parameter Query No Results - Needs to Auto Create Record 4
Access Dcount (multiple criteria) 3
Adding a query result to a form in Access 2007 1
Query result to text field 1
result query on a form 1
Narrowing query results 16

Back
Top