Search results

Thanks for the idea John but this is what I tried originally - it doesn't work as all that seems to happen is if the first record is a type 4 it evaluates that one but not any of the other ones ie the total always becomes 140

Hi hope you can help - I have a lesson booking database and am using a report to create an invoice. The report backs onto a query where you can specify a range of dates (parameter queries) which lists matching lessons in that date range. Each lesson booking has a lessontype (there are several)...

AWESOME! Just tried it and it works a treat thank so very much Cheers Sean

So - what if I get you right what I could do is make a query which searches the bookings table for a specific date and time (query1) and then do an unmatched query against query1 - is that right?

Brilliant - thanks. Almost there! I just tried it and it works great but how can I limit it to a specific date? At the moment it just (un)matches all tables so that basically if a table only has to be booked once in the past at any date or time for it NOT to show in the results The structures...

Quite new to Access so hope this makes sense - I have a restaurant table booking system. Works well but ideally what I want to do is search for tables that haven't been booked yet. However I don't know how since I'd need to search the bookings table but that of course is populated with existing...

Thanks Bob for such a speedy answer (!) - could I possibly ask you to elaborate slightly ... where would I find the master/child link settings or do you just mean the relationship links between the tables as in one to many etc?

Hi, I have a form which three tabbed sections on it. On two of these there are subforms related obviously to the main/parent form. The tables are definitely related and connected properly. My problem is this: when I move through the main/parent form using the standard navigation buttons (or...