Access Question (1 Viewer)

[Asuka]

I am new to access and have a question which is most likely simple. but I have a database and I need in my query to be able to pick what entrys were made between this date and another date.

In design view on my query I have this in here on the Line I want to search

Between [Enter Start Date] And Date()


Works fine but I need a stop date it will only search from a date I put in all the way to current.


thanks for your help
Chris

 

[AnnaFoot]

Hello,

Date() means the current date. So if you change your criteria to:

between [enter start date] and [enter end date]

you will be able to enter the two dates you require.

If you are not located in the US, be careful of the BETWEEN function and dates not specified mm/dd/yy

Anna