Finding sequences in a query‏

[Bartus]

I'm am making a small programm for seat reservations. But I have a problem to find the sequence in the available seats. I will explain it with the following sample:

Row / Seat / Total Seats In Sequence / Sequence number / Available
1   /  1   /              3          /        1        /     3
1   /  2   /              3          /        2        /     2
1   /  3   /              3          /        3        /     1
1   /  6   /              4          /        1        /     4
1   /  7   /              4          /        2        /     3
1   /  8   /              4          /        3        /     2
1   /  9   /              4          /        4        /     1
2   /  1   /              3          /        1        /     3
2   /  2   /              3          /        2        /     2
2   /  3   /              3          /        3        /     1
2   /  8   /              2          /        1        /     2
2   /  9   /              2          /        2        /     1

If have tried to do it with Dcount but this function is very slow. The output of available seats is the row that I use for the rest of the database.

Please let me know if you have a better solution to get the availeble seats next to each other as an output.

For example if I need 3 seats the system have to give me to following options:

Row / Seat / Total Seats In Sequence / Sequence number / Available
1   /  1   /           3             /        1        /     3
1   /  6   /           4             /        1        /     4
1   /  7   /           4             /        2        /     3
2   /  1   /           3             /        1        /     3

Hope that you can help me, maybe Ecount works better but I can't figure out I can make it work for my query.

Best regards
Bart

[FishVal]

Hello, Bart.

Frankly speaking I don't understand the meaning of 3 last fields.
However, to determine contiguous seat groups you need only Row, Seat, Reserved/Available fields. The rest is redundant.

Is that the case or the fields have some special meaning?

Regards,
Fish.

[ADezii]

I do agree with FishVal concerning the redundancy, but in any event, here is the SQL. Better yet, download the Attachment.

PARAMETERS [Enter Minimum Number of Seats Needed] Long;
SELECT tblSeatReservations.Row, tblSeatReservations.Seat, tblSeatReservations.[Total Seats in Sequence], tblSeatReservations.[Sequence Number], tblSeatReservations.Available
FROM tblSeatReservations
WHERE (((tblSeatReservations.Available)>=[Enter Minimum Number of Seats Needed]));