Printing Daily Report for Existing Members

[Rabihk]

Dears,

I have a kids club which do lots of functions for kids, to monitor the members and who is in and out I did a small access data base with details of Start date of the function and end date for each member.

I want to make a daily report showing only the active members in today date only for example:

Jack have swimming every Saturday, Monday and Wednesday Between 14 July 2015 till 14 August 2015
Jill have swimming every Sunday, Tuesday and Thursday Between 14 July 2015 till 14 August 2015

today is 11 August 2015 and I want to report to mention just who is active today only.

Please advise. and Thank you.

[ranman256]

Instead of using the table, build a query called qsActiveMembers
select * from tMembers where [enddate] is null or [EndDate] <= date()
This way all your future queries would run off qsActiveMembers.

Now for scheduling,
Select * from qsActiveMembers, tSchedules,tDates INNER JOIN tSchedules ON tMembers.ClientID = tSchedules.ClientID
you would list the days of the week along with the dates of the member's schedule along with the [endDate].
If the DateOfWeek <= [EndDate] then youd show Swimming, else show EXPIRED.

[Rabihk]

Instead of using the table, build a query called qsActiveMembers
select * from tMembers where [enddate] is null or [EndDate] <= date()
This way all your future queries would run off qsActiveMembers.

Now for scheduling,
Select * from qsActiveMembers, tSchedules,tDates INNER JOIN tSchedules ON tMembers.ClientID = tSchedules.ClientID
you would list the days of the week along with the dates of the member's schedule with the [endDate].
If the DateOfWeek <= [EndDate] then youd show Swimming, else show EXPIRED.

Thanks ranman. Do you mean i have to make seperat table for schedules and another table for tables?

[ranman256]

no 1 table for persons
1 table for schedules