Ok people I have a problem and your going to sit down an listen!
Im currently working on a project in MS access, that counts for 50% my final IT mark. Given a choice, I would have made t3h most ubar-1337 web project there could be, but I cant. This is for my milk man.
My problem is this:
I have 2 tables, one containing customer info, and one containing information (CustomerID, StartDate, EndDate) about customer holidays. When a customer is on holiday, they dont get any milk delivered. Now, I have come to writing some queries. What I need is a query that includes
ALL customers who have no holidays (i.e. no records in tblHolidays)
ALL customers who are not yet on holiday (i.e. Todays Date < StartDate)
ALL customers who are back from holiday(i.e. Todays Date > EndDate).
Currently Im screwed on how to do this, I can get customers up who have holidays booked but are not on them, but not those who dont have any holidays.
The project is located
Here (180kb Zip, MS Access 97)
Help Pls