Functions in Access 2003

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
 
D

DL

Lookup the "If" function and use that function in an event handler for DOB
field to populate the DueDate Field

Since there are 4 quarters it would be a nested function to allow for the 4
DueDates
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top