F
Faireedoll
Hi,
I am hoping someone can help.
i am building a database for our staff details, and need some help wit
what i think would be a function.... i could be wrong.
Our staff have to renew their Registration once a year, this is don
quaterly based on the staff members date of birth. At present if a staf
members DOB falls between 1st July and 30 Sept then their renewal is du
on 1st october. so i manually enter this into the due date field that
originally created.
Is there a function or an if value that i can place on this field tha
says that if DOB = (01 july 01/07/- 30 sept 30/09) then due date = 1s
october... (i have written the mth as i am in New Zealand and we plac
day before mth incase you thought i already had it wrong by putting a
incorrect date in).
I am quite new to Access so not even sure if this is at all possibl
and are only assuming that it would be an expression or function.
Any help greatly appreciated, Thanks Mon
I am hoping someone can help.
i am building a database for our staff details, and need some help wit
what i think would be a function.... i could be wrong.
Our staff have to renew their Registration once a year, this is don
quaterly based on the staff members date of birth. At present if a staf
members DOB falls between 1st July and 30 Sept then their renewal is du
on 1st october. so i manually enter this into the due date field that
originally created.
Is there a function or an if value that i can place on this field tha
says that if DOB = (01 july 01/07/- 30 sept 30/09) then due date = 1s
october... (i have written the mth as i am in New Zealand and we plac
day before mth incase you thought i already had it wrong by putting a
incorrect date in).
I am quite new to Access so not even sure if this is at all possibl
and are only assuming that it would be an expression or function.
Any help greatly appreciated, Thanks Mon