Search results

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...

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...

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...