Search results

! Smashing thanks.:)

Hi, here is my query: SELECT DISTINCT tblvisit.[Pen ID] FROM tblvisit WHERE (((tblvisit.[Visit Date From])<=[forms]![fRMBOOKINGAVAILABILITY]![From]) AND ((tblvisit.[Visit Date To])>=[forms]![FRMBOOKINGAVAILABILITY]![To])) OR (((tblvisit.[Visit Date From]) Between...

Just what I thought... Yeah, that's what I was hoping someone could help me with. Can anyone therefore tell me how to do this in code: I have a query that finds out if there are less than 40 cats in on one day. How do I repeat this query for each day that the cat wants to stay - remember...

Here is a challenge for the best of you! I have a cattery system which will be using the following tables: tblCAT tblVisit and so on I need to be able to check booking availibility. NOTE: THIS IS NOT THE SAME AS A HIRE-SERVICE SYSTEM. I.E. I need to be able to check the following: 1. For...

Not really what I meant Sorry, that sort of query just finds any pens which could accomodate the whole of a cat's stay, wheras in reality, that wouldn't be very efficient; consider... A cat is booked in from 1st Jan - 3rd Jan in pen 1. A customer wants to put their cat in from the 1st to the...

Listing of database Hi, I haven't got a copy with me at the moment. Basically though, I need a query utilising the following: VISIT(Visit_Ref, CatID, PenID, Visit_From, Visit_To etc.) CAT(CatID, CustomerID, etc.) PEN (PenID, Pen_Type, etc.) There are 20 pens and the query needs to ask 'is...

Hi, here is the general schema: tblCat, tblCustomer, tblPen, tblVisit, tblTreatment, tblCarePackage, tblEmployee When a customer makes a booking, all I need to do is check that there is less than 20 cats in the cattery for every day of the customer's intended visit range. This isn't the same...