Im doing a database booking system and i need to limit the amount of people to 160 per night. At the moment i have a query that sums up the bookings per date but i dont know how to then limit this column to 160.
<160 would limit the records displayed to 160 or less, but i'm not sure if thats what your trying to do, are you trying to limit the number of entries that can be entered for each night??????
Limit the amount of entries to 160 per night 1 person can make a booking for multiple people so i added this up so that i get a total for the amount of people per night i then need to limit this number to 160 so that no more bookings can be taken after 160.
