Queries w/date criteria don't run

  • Thread starter Thread starter debbie jackson
  • Start date Start date
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.
 
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.
 
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). :-)
 
Back
Top