C
Charlie Klein
Hello Access people:
I am a computer simpleton. For an organizationl
membership database I set up in Access, I need to create a
formula that will fill in the "Membership Expires" field
by looking at the "Date Joined" field, adding one year,
and then inserting the date of the last day of the month
of that year. E.g.: John Smith joins 7/16/04. When that
date is entered in the "Date Joined" field, I want
the "Membership Expires" field to automatically fill in
7/31/05 (with the possibility that the expiration date can
be changed manually if necessary). Can someone tell me
how to do that?
Thanks,
Charlie Klein
I am a computer simpleton. For an organizationl
membership database I set up in Access, I need to create a
formula that will fill in the "Membership Expires" field
by looking at the "Date Joined" field, adding one year,
and then inserting the date of the last day of the month
of that year. E.g.: John Smith joins 7/16/04. When that
date is entered in the "Date Joined" field, I want
the "Membership Expires" field to automatically fill in
7/31/05 (with the possibility that the expiration date can
be changed manually if necessary). Can someone tell me
how to do that?
Thanks,
Charlie Klein