You may want to look at the function of DateAdd or DateDiff. Both of these
function will do what you would like to see.
HTH
Jose
sdl_7 <[EMAIL PROTECTED]> wrote:
is there a way to have a field in a table that uses the date from one
field and adds day to it to creat a new date?
example: field 1(job date) has a date of 3/24/6. i want to have
another field 2 called job end date which is 30 days after the field
one date.
thanks
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "ms_access" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
