I have a club management system for which I'd like to easily see in a report which members 'have and which have not' paid their current months membership fee... What would be the best way of achieving this please?
Currently I have one table for payments and another for members combined in a view which feeds into a tabular report that filters payments with an 'active Y/N status' (paid), as well as where the payment amount 'is blank' (unpaid). However the problem with this is that I don't want to display previous / future months payments. Members who've only ever paid in previous months are also displaying as 'Paid' for the current month despite not having made their current month payments (some members are also appearing multiple times for each of their past payments).
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Afzal1
I have a club management system for which I'd like to easily see in a report which members 'have and which have not' paid their current months membership fee... What would be the best way of achieving this please?
Currently I have one table for payments and another for members combined in a view which feeds into a tabular report that filters payments with an 'active Y/N status' (paid), as well as where the payment amount 'is blank' (unpaid). However the problem with this is that I don't want to display previous / future months payments. Members who've only ever paid in previous months are also displaying as 'Paid' for the current month despite not having made their current month payments (some members are also appearing multiple times for each of their past payments).
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.