Queries w/date criteria don't run

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

 

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

 

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

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