Auto generate value

[crescent-centre]

I am a fairly new user of Access and need some help with some code. I have a date field which is filled in by the user containing the date a drawing is received into the office. I want a second field to be automatically generated for the date the drawing needs to be processed by, date in + 14 days. Currently the user is having to calculate this field manually. Any help. Is this a case for VB or macro.

Paul

 

[Mile-O]

As it's calculable, you don't need to store the date in your table - if you need it for reports or forms you can make a query which will add 14 days to your original date in a new query field.

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=42980


We have to stop bumping into each other like this Mile, people will start to talk