Query Field Name based upon Text Box value

[Malcolm17]

Brilliant, thank you for that, I have something similar in my main database, but what you are showing is what I was thinking about where we manually select tables ( T1 + T2 + T3 ) on a continuous form, this does solve my problem, where I was trying to be a little more adventurous and be able to select one option to book say all tables in the room. (Initially thinking this might be possible with a crosstab query)

I’ll have a think and look again tomorrow if I have a chance.

Many thanks again,

Malcolm

 

[Gasman]

So you book a room, and not a table?

 

[mike60smart]

So you book a room, and not a table?

No
In the example Smith has booked Tables 7, 8 & 9
When you move to a new record for Jones - book required table(s)

 

[Malcolm17]

Mainly it would be to book an individual table up to 4 people, but often it would be to book 2 tables joined together (eg 7 & 8) for a party of say 8 people, rarely you’d want to select all tables in the room for a booking.

That’s the challenge here:
Table 7 can be used on its own
Table 8 can be used on its own
Tables 7 & 8 can be joined to make an 8
All Tables (inc 7 & 8) can be joined to make a table of 40.

The challenge is not showing a group if it has any of its individual tables booked, or not showing any of it’s individual tables if it’s booked as a group.

Malcolm

 

[Gasman]

Cannot believe you would not have the option of having private functions, but you know your business best.

 

[Malcolm17]

I’m trying to lose our restaurant booking system to save costs and build it in to our MS Access Diary system that logs staffing, maintenance, health and safety etc which we use and it emails management a report at the end of the day, also links to our tills data.

More than that I’m keeping myself occupied in my spare time and learning more. It’s been my wee project for the past 10 years on and off.