Queries w/date criteria don't run

D

debbie jackson

Has anyone experienced the following:
Query will not run when date criteria is used.

Example:

Selecting a group of records from the "Entrydate" field.
Query is structured as follows:

Entrydate between #03/01/04# and #12/31/03#

The Run command produces no response. No error prompt is
shown.

Anyone else come across anything similar????

Thanks in advance for any help given.
 
R

Rick B

Well, for one thing, your dates are backwards.

March 1 of 2004 comes AFTER December 31 of 2003, so I'm sure Access is quite
confused by that statement.

Rick B


Has anyone experienced the following:
Query will not run when date criteria is used.

Example:

Selecting a group of records from the "Entrydate" field.
Query is structured as follows:

Entrydate between #03/01/04# and #12/31/03#

The Run command produces no response. No error prompt is
shown.

Anyone else come across anything similar????

Thanks in advance for any help given.
 
F

fredg

Has anyone experienced the following:
Query will not run when date criteria is used.

Example:

Selecting a group of records from the "Entrydate" field.
Query is structured as follows:

Entrydate between #03/01/04# and #12/31/03#

The Run command produces no response. No error prompt is
shown.

Anyone else come across anything similar????

Thanks in advance for any help given.
Click to expand...

Try using a 4 digit year.
between #03/01/2004# and #12/31/2003#

The backward order shouldn't matter (though it is a bit harder for us
humans to read). :)
 
Top