Using 5 queries to create sub forms based on dates

[daniel1676]

My goal is to have one form with five sub forms in it (one subfor to a query). Each sub form will display all the bookings for one day e.g. sub form 1 displays for tuesday, sub form two will display wednesday.

As saturday and sunday take no bookings their is no need to display these two days but if i put in the query date+1 etc then these two days will be displayed.

My question is: How do i set up a query to look out for staurday and sunday and skip to monday. Secondly how do the get the querires after that to go to tuesday, wendesday etc.

Any additional information just ask

 

[daniel1676]

have added this code to the first query:
IIf(Weekday(Date())<>1 Or Weekday(Date())<>7,Date(),IIf(Weekday(Date()+1)<>1 Or Weekday(Date()+1)<>7,Date()+1,Date()+2))