QUERY CRITERIA

  • Thread starter Thread starter DENISE
  • Start date Start date
D

DENISE

IF I USE [ENTER DATE] IN THE CRITERIA FIELD, IT WORK FINE
TO RETRIEVE A NEEDED DATE. BUT CAN I STILL GET ALL THE
DATES IN THE FIELD USING THE SAME QUERY. IS THERE A WORK
LIKE "ALL" IN ORDER TO RETRIEVE ALL RECORDS?
 
IF I USE [ENTER DATE] IN THE CRITERIA FIELD, IT WORK FINE
TO RETRIEVE A NEEDED DATE. BUT CAN I STILL GET ALL THE
DATES IN THE FIELD USING THE SAME QUERY. IS THERE A WORK
LIKE "ALL" IN ORDER TO RETRIEVE ALL RECORDS?
Click to expand...

Posting in all caps is considered shouting in all newsgroups, and is
rude. Please post using normal typing.

To answer your question, change the query parameter from
[Enter Date] to:

Like IIf(IsNull([Enter Date]),"*",[Enter Date])

If you leave the prompt blank you will get all the records.
 
[Enter Date] Or [Enter date] Is Null

The above will get all dates when you don't enter a date at the prompt and
just press enter.

BTW, all caps is termed "shouting" and is considered impolite!
 
Thanks for the heads up on Caps! And a special thanks for
the answer
-----Original Message-----
[Enter Date] Or [Enter date] Is Null

The above will get all dates when you don't enter a date at the prompt and
just press enter.

BTW, all caps is termed "shouting" and is considered impolite!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com



IF I USE [ENTER DATE] IN THE CRITERIA FIELD, IT WORK FINE
TO RETRIEVE A NEEDED DATE. BUT CAN I STILL GET ALL THE
DATES IN THE FIELD USING THE SAME QUERY. IS THERE A WORK
LIKE "ALL" IN ORDER TO RETRIEVE ALL RECORDS?
Click to expand...


.
Click to expand...
 
Thanks for the heads up on Caps! and a special thanks for
the answer to my question
-----Original Message-----
IF I USE [ENTER DATE] IN THE CRITERIA FIELD, IT WORK FINE
TO RETRIEVE A NEEDED DATE. BUT CAN I STILL GET ALL THE
DATES IN THE FIELD USING THE SAME QUERY. IS THERE A WORK
LIKE "ALL" IN ORDER TO RETRIEVE ALL RECORDS?
Click to expand...

Posting in all caps is considered shouting in all newsgroups, and is
rude. Please post using normal typing.

To answer your question, change the query parameter from
[Enter Date] to:

Like IIf(IsNull([Enter Date]),"*",[Enter Date])

If you leave the prompt blank you will get all the records.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top