Dates and Access

[Hanna]

I have member database, all my members have a date when
they joined. Different types of memberships gives
different length of memberships. I want my data base to
count the end date of the membership.

Ex:
Mary joined 1/jan/2000 with a 6 (1 Jan+ 182 days) months
membership, I want Mary's end date to show 1/jul/2002

Ann joined 1/jan/2000 with a 12 (1 Jan+ 365 days) months
membership I want Ann's end date to show 1/jan/2002

 

[Steve Schapel]

Hanna,

Somewhere in your tables, you will have a field which shows the length
of membership. Sounds like you do this in days, whereas I imagine
most such organisations would use months. But whatever, it doesn't
really matter, but it would be simpler if the unit used were the same
in all cases. It is not clear from your post whether this data would
be in a MembershipCategory type of table, or in the Members table, or
what, and I would need to know more about your project to know what
was appropriate here. But, when it comes to the end date, this would
not be stored anywhere in a table. Whenever you need this date, for
your purposes of form or report, you can calculate it, either directly
on the form or report, or else in the query that the form or report is
based on, by simply adding the MembershipLength to the JoinDate or the
last RenewalDate.

- Steve Schapel, Microsoft Access MVP