By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,248 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,248 IT Pros & Developers. It's quick & easy.

Club membership problem

P: 1
I have created a database (New to Access) to keep track of the club members. BUT I want to record the start dates and finish dates of the members fees. I want to be able to look back and see what members paid fees and from and to dates. Is this possible and anybody have an idea how I could do it.

Thanks
Ger
Jun 18 '19 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,419
Create a table with a Foreign Key to the table used for members and in that new table store fees paid and when.

I've been deliberately general as you share very little of your situation and this question seems to be of such a basic level that I'm inclined to advise you start by doing some very basic learning about the whole concept of what a database does before you try to progress further.
Jun 18 '19 #2

zmbd
Expert Mod 5K+
P: 5,397
Gerry21>Bytes.com>Inbox
Sent you a copy of some reference materials that you may find handy as you grow with Access. In particular look at the normalization links. :)

Neopa has a good starting point for you.

Something you might want to consider is instead of storing the start-end-dates maybe store the start, subscription length?
Something like
PK_Subs, fk_member, Paid_Date, Start_Date, Membership_Term

then you can query where elapsed days between current date and start_date are >= membership_term, along the same lines as calculating someone's age...
Allen Browne(MVP)>Age()
Jun 18 '19 #3

Post your reply

Sign in to post your reply or Sign up for a free account.