OK im nealry done with my database but i am stumped on these two things:


1. a list of bookings every saturday to saturday, so u put in a date in a query and it shows all data within 1 week of that date

2. Monthly calculation on the
-total money taken for occasional bookings

-and the percentage usage, based upon data i have inputted, 21 slots how to work it out

Many thxs

That very much depends on how you have structured your database and you don't give that info.

for #1 I'd recommend you pass MySQL (etc) the actual dates for the query rather than leave it to work it out. Only a few extra lines in your script and faster in the database.