By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,454 Members | 2,629 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,454 IT Pros & Developers. It's quick & easy.

Date Clash Query Help Please

P: 37
Hi everybody,

I have an access database that books houses for people to stay in. I'm trying to build a query which will find clashes in booking dates, ie it will compare arrival and departure dates of houses and if there is an overlap of dates, those houses with booking clashes will be listed. I'm trying to write an iif statement to compare dates but I can't get my head around how to go about it. Any help would be massively appreciated cos I accidentally discovered one booking clash and now I'm worried there may be others.

My table where the info is being pulled from is tblRRCustomers, the fields are
Property
ArriveDate
DepartDate
IDCustomers

Thank you for your thoughts

Eddie
Mar 20 '08 #1
Share this Question
Share on Google+
3 Replies


FishVal
Expert 2.5K+
P: 2,653
Hi, Eddie.

There are several threads in the forum dealing with the same.
For starters you may check the following.
How to prevent overlapping schedules?
How to prevent the overlapse range entry ?
Iif query

Regards,
Fish
Mar 20 '08 #2

P: 37
Thanks for the pointers Fish, I adapted the Hair Salon and it works great.
Cheers Eddie
Mar 23 '08 #3

FishVal
Expert 2.5K+
P: 2,653
You are quite welcome.

Best regards,
Fish.
Mar 24 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.