Date Range - Parameter Query Problem

kappa

I have a problem in ALL my queries when I run a specific date range. Access always crashes when I view in Datasheet view. This doesn't occur if it's a parameter query and I am prompted to enter the date range. Eg.

Between #1/01/2006# And #31/12/2007# - This would crash

Between [enter start date] And [enter end date] - This would be OK

Can someone please help!!

FishVal

Quote:

Originally Posted by kappa

I have a problem in ALL my queries when I run a specific date range. Access always crashes when I view in Datasheet view. This doesn't occur if it's a parameter query and I am prompted to enter the date range. Eg.

Between #1/01/2006# And #31/12/2007# - This would crash

Between [enter start date] And [enter end date] - This would be OK

Can someone please help!!

Hi, kappa.

Pay attention to date format. Access SQL accepts dates in m/d/y format.
This maybe confusing bkz query parameter dialog accepts dates in format defined in your regional settings.

Date Range - Parameter Query Problem

re: Date Range - Parameter Query Problem

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about