Help with Query: Specifying Time - From Date Until Date

[simon_t]

Hey.

I have a database, and in this database, there are bookings.

For a query, I want to be able to view all bookings from date 1 to date 2.

E.g.

Date one is 12/02/2009 and date two is 23/07/2009

How can I make my database do that, so I can see all of the bookings in between those dates?

Thanks!

 

[Joe4]

Welcome to the Board!

In the Criteria row under that date field, enter your criteria like this (assuming the fields are formatted as date fields and not text):

Between #12/02/2009# and #23/07/2009#