Generate Month view

[verhp11]

Situation:


A database with members of a sport club.
Every month they pay the same fee

Whish:
Automatic generate a list per month of members with the amount they have to pay
At the end of the line a checkbox to record if the did pay which saves it to the monthrecord


Question:
What is the best way to accomplish this?

Thank you,
Peter

[ranman256]

on a form, put 2 text boxes,txtStartDate, txtEndDate
the query will use this as a range to pull data:
select * from table where [MyDate] between txtStartDate and txtEndDate

[verhp11]

Hi Ranman, thank you for your reply.
I understand your example, but the thing I can't get done is that I want to have a report or dynamic table where I want to show (indeed start and end date) the month filled with all members and the payment they have to do, then in that report / table I want to be able to mark that it is paid or not. So I can see in one single instance who have and haven't paid per month, any tip on how to realize this?

Thank you !!

[ssanfu]

<snip> but the thing I can't get done is that I want to have a report or dynamic table where I want to show (indeed start and end date) the month filled with all members and the payment they have to do, then in that report / table I want to be able to mark that it is paid or not. So I can see in one single instance who have and haven't paid per month, any tip on how to realize this?

Don't know what you mean by "dynamic table", but I would NOT use a report (nor a "dynamic table"??) . Reports are for printing, not data entry. I know that MS allows it, but if you are going to enter data, use a form. That is what forms are for.

I would have a form that shows all records (and the fields you want to see) in continuous forms view. In the header I would have two combo boxes. One to show the months of the year and the other to show the years. A button in the header would set a filter to limit the records for the selected month/year; VBA code would calculate the BOM and EOM dates.
You could also have an option to show unpaid members for the selected month/year. Of course, there would be a button to remove the filter and show all records.