Prompt to include all records or choose just some records

[jhicsupt]

In a query, is there a way to allow the user to include records starting from
a particular date, however allow them to also include ALL records?

My command is ">=[Enter Beginning Invoice Date]"

So in this instance, if they put in 10/1/2008, it would include all invoices
with dates >= 10/1/2008. However I would also like them to be able to press
OK and pull all records.
So my command would be [Enter Beginning Invoice Date or Press OK for All]

What is the command for this?

Thanks in advance.

 

[Ken Sheridan]

Change the criterion to:

=[Enter Beginning Invoice Date or Press OK for All] OR [Enter Beginning Invoice Date or Press OK for All] IS NULL

If the user does not enter a date then '[Enter Beginning Invoice Date or
Press OK for All] IS NULL' will evaluate to True for every row, all of which
will consequently be returned.

Ken Sheridan
Stafford, England

In a query, is there a way to allow the user to include records starting from
a particular date, however allow them to also include ALL records?

My command is ">=[Enter Beginning Invoice Date]"

So in this instance, if they put in 10/1/2008, it would include all invoices
with dates >= 10/1/2008. However I would also like them to be able to press
OK and pull all records.
So my command would be [Enter Beginning Invoice Date or Press OK for All]

What is the command for this?

Thanks in advance.