I am working on a database for a Gym. I am trying to run a Class List Query by Date - and have a factor I can't figure out how to include in the query.
The User wants to be able to enter a session date (typically 8 weeks) into a form for a particular class and get a class list. I have a form set up so she can choose the class via combo box, enter the start date for the session. The form would then add the 8 weeks and put the end date in for the user. The query will then find everyone in that class who either Registered for it during those dates or whose Membership expires during those dates. And it works.
for Background: When a client Registers for a class, the user enters the registration date and their renewal date for that membership is automatically calculated by the number of weeks that the membership is. There is also a field where days can be added to the membership as the gym will give extra days/weeks for referrals etc. The Renewal Date formula is
DateAdd("ww",[MembershipLength],[RegistrationDate])+[AddDays]
The extra factor is: a member can have days added [AddDays] to their membership. It could be 5, 7, 14 etc. With the way it's set up - it the client registers the day before a new session starts, so for ex. Aug 31 - and then runs the query for Registrations/Renewls from Sept 1 to Oct 31, the query would catch them as their renewal date would end up in the 8 weeks that are queried. However, if they refer someone and have days added, now they get missed off that class list, b/c their registration date is before the dates queried and the renewal date is now longer then the 8 weeks and outside of those 8 weeks.
Any suggestions on how to include this scenario?
I figured out how to do multiple OR statements