Date formulas

[Guest]

I need help with a date formula i have. I have three field one call Admin
Review which had the dates the review was done, then i have next admin
review, which depends on the Amount of days given to review the case. What i
need is that when i type in the number of days given it automatically gives
me the next review date. Example:

Review Date Number of Days Next Review Date
10/30/05 30 11/30/05

 

[Guest]

Use the function DataAdd to add the days to the date field, Using a query

Select [Review Date], [Number of Days], DateAdd("d",[Number of Days],[Review
Date]) As [Next Review Date] From TableName

Or, you can use it in a field in a form
in the control source of the field, you can write

=DateAdd("d",[Number of Days],[Review Date])

If you are thinking of saving the output in a seperate field in the table,
then don't just use the select query to return the next date.