J
janmd
I have created an Event Management database but now want to add to
this to assign seats to people attending an event. The event will run
through several days, and I want to be able to assign people their
required number of seats, where the better seats are assigned first.
If someone has asked for 5 seats, I need to search for where there are
five seats next to each other, not two together, then an aisle, then
three together, etc.
Is this at all possible?
I am not a VBA programmer, so need to be able to set up the relevant
extra table for seats which should be reasonable straight forward, but
then not sure how to go about a query for assigning the seats.
this to assign seats to people attending an event. The event will run
through several days, and I want to be able to assign people their
required number of seats, where the better seats are assigned first.
If someone has asked for 5 seats, I need to search for where there are
five seats next to each other, not two together, then an aisle, then
three together, etc.
Is this at all possible?
I am not a VBA programmer, so need to be able to set up the relevant
extra table for seats which should be reasonable straight forward, but
then not sure how to go about a query for assigning the seats.