Managing Sporting Club Annual Fees (1 Viewer)

mjones

New member
Local time
Today, 19:03
Joined
Jan 5, 2020
Messages
3
I have an access database that is used to manage the members of a sporting club, although at the moment it is pretty basic.

All members pay an annual membership, plus they may also have extras, such as locker hire. There are different types of membership (Full, Junior, Life etc.). What I want to be able to do is generate invoices, then record payments as they come in, and make a list of outstanding memberships. Basically I am after advice as to the best way to handle all of this. At the moment I have a table that contains all the member's details, another that has all the membership fees, but that's about it. I am pretty new to access (I really don't even know where to store the calculated annual fee!), so please use little words!

Matt
 

Ranman256

Well-known member
Local time
Today, 07:03
Joined
Apr 9, 2015
Messages
4,339
the tMemberFees table:
MemID, FeeName, FeeAmt
641, Membership Fee, 100
641, Locker Rental, 25
321, Membership Fee, 50

tMembers tbl:
MemID, Name, MemberType
641, H. Simpson, Full
321, Bart Simpson, JR

tFees
FeeName, FeeType, FeeAmt
Membership Fee , Full, 100
Membership Fee, JR, 50
Locker Rental, 25

the tMemberCharges table:
MemChgID, MemID, FeeName, FeeAmt, DateCharged, DatePd
123,641, Membership Fee, 100, 1/1/20
124,641, Locker Rental, 25, 1/1/20
125,321, Membership Fee, 50, 1/1/20

tMemberPayments tbl:
PayID, MemID, DatePd, AmtPd, PdHow, Memo
132, 641, 1/2/20, 125, check, #123

at the start of the month ,I run an append query that adds the tMemberFees to the tMemberCharges table.
reports can then show each members missing payments, etc
 

Users who are viewing this thread

Top Bottom