Date Range Query

[Sheri]

I have a field in my table called DelDate it is a Date/Time formatted
field. I want to query a date range.

For example I want [Enter Beginning Date] and [Enter Ending Date] to
be user imputted when the query is ran.

I have tried >=[Enter Begining Date],<=[Enter Ending Date] but it
isn't working.

Please help.

Thanks,
Sheri

 

[Marshall Barton]

I have a field in my table called DelDate it is a Date/Time formatted
field. I want to query a date range.

For example I want [Enter Beginning Date] and [Enter Ending Date] to
be user imputted when the query is ran.

I have tried >=[Enter Begining Date],<=[Enter Ending Date] but it
isn't working.
Try:

=[Enter Begining Date] And <=[Enter Ending Date]

If the DelDate field has a time part, then use:

=[Enter Begining Date] And <[Enter Ending Date] + 1