Dates in criteria again

  • Thread starter Thread starter Louise
  • Start date Start date
L

Louise

Dear Experts,

Now you have sparked my curiousity:) Can you enter two
dates and have access scan available rooms for occupancy
during those times? The table I have books students into a
bed with a code between an arrival and leaving date.

many thanks

Louise
 
In a query, you can use the Between ... And syntax to bracket a range:

Between #1/1/2004# And #1/31/2004#
 
Yes, you can.

From your description, I am guessing that you have a record something like

StudentID, RoomNumber, DateIN, and DateOut.

You are trying to get roomnumbers that are occupied between two dates
(StartPeriod, EndPeriod)

That means that the DateIN should be BEFORE the EndPeriod and DateOut Should be
AFTER StartPeriod. This will get every room that is occupied AT SOME TIME
during the StartPeriod to EndPeriod.

WHERE DateIN <=[End Period] AND DateOut >= [Start Period]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Between Dates Criteria 2
Dates in query criteria 4
criteria on form 1
Date criteria 4
Prices on Date Schedule 1
Who has the solution to this problem ?????? 3
date criteria 1
Criteria selects data both in and outside user defined date parame 4

Back
Top