I am working on a laser tag database where I have to schedule laser tag games (each game is 15 minutes long or 30 minutes long).
There is a group who wants to play a 30 minute game but each entry is 15 minutes long. I can use Visual Basic 6 to check a table and see
if one 15 minute game is available but I cannot run a check to see if two consecutive 15 minute blocks are available. How do I
check to see if two consecutive 15-minute blocks are available?
A Sample of the Table:
Game ID Game Time Number of Players Type of Game
1 12:15 PM 8 Team Game
2 12:30 PM 6 Free For All
3 12:45 PM 6 Free For All
4 1:00 PM 12 Capture The Flag
There is a group who wants to play a 30 minute game but each entry is 15 minutes long. I can use Visual Basic 6 to check a table and see
if one 15 minute game is available but I cannot run a check to see if two consecutive 15 minute blocks are available. How do I
check to see if two consecutive 15-minute blocks are available?
A Sample of the Table:
Game ID Game Time Number of Players Type of Game
1 12:15 PM 8 Team Game
2 12:30 PM 6 Free For All
3 12:45 PM 6 Free For All
4 1:00 PM 12 Capture The Flag