Query - Coniditonal Criteria

  • Thread starter Thread starter SAC
  • Start date Start date
S

SAC

I would like to make a conditional criteria for a column in a query.

If a control is null I'd like to see all record. If it's not null then I'd
like to restrict the records to the date in the control.

How would I do this in the criteria of the query?

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

Access Dcount (multiple criteria) 3
Parameter Value error in a Subform 0
Query based on Check Box 1
Criteria from Form 3
VBA: How can I use a string variable as autofilter criteria? 4
NOT function not working - can prove with screenshots 1
Is Null 2
Data Mismatch in Excel 2010 4

Back
Top