Club membership problem

[Gerry121]

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

[NeoPa]

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.

[zmbd]

Gerry21>Bytes.c om>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 ()