Select between 2 dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a query that will return data between 2 user defined dates. A pop up window needs to appear asking the user the start date and end date in the format xx/yy/zzzz. Can you show me what the query expression should look like. I could find help on queries within the access 'help' menu but it did not give me exactly what I wanted.

Thanks
 
Hi

in the criteria line type

BETWEEN [Enter Start Date (dd/mm/yyyy)] AND [Enter Start Date (dd/mm/yyyy)]

- this can also be linked to a form for greater error checking etc.

Regards
JulieD

RC said:
I want to create a query that will return data between 2 user defined
Click to expand...
dates. A pop up window needs to appear asking the user the start date and
end date in the format xx/yy/zzzz. Can you show me what the query expression
should look like. I could find help on queries within the access 'help' menu
but it did not give me exactly what I wanted.
 
Back
Top