Query for clashes, How to show what is available first? and then use the resource?

[tony30]

Hi:


Thanks to the previous and kind help I was able to get this database up and running, the clashes in the bookings are shown in the bookingform as a subform, so I just need to change a different spot and look when the subform is "clear" and save the booking, all is fine, now my picky boss wants to KNOW in advance which parking spots are "free" now, instead of manually changing one by one and see which one clears the subform.....is there any easy way to implement this? the parking system is a booking system like an hotel... One query can tell me who will be departing TODAY, so those spots will be "clear" at least at NOON, how we can account the ones that are not booked also? ...He also asked me if we can register delays in checkin out, ie. when someone ask for few hours extra something like an "late departure" in hotel lingo...
Thank you again.
Tony

[pbaldy]

In general, you can create a query of everything that is booked right now, then use the unmatched query wizard to compare that to the table of all parking spots. That should result in the available spots.

[tony30]

Thank you, Paul, That was a great idea , , I would like it , however, to to make it work for future reservations,being able to see no what is available for a given period (in the future)... any suggestions?
Thanks again
tony30

[pbaldy]

Same concept, but make the first query use a date or date range on a form.

[tony30]

I tried, did not work..., however I need a more detailed explanation , how the query would "pick " the form values?
I don't know VB enough yet.
Thanks

[pbaldy]

Wht did you try that didn't work? No VB required, you use form controls in the query criteria. This might be relevant.

http://www.baldyweb.com/OverLap.htm