Auto populating date.

[emccalment]

I'm working with a database intended for reporting use. Now, we have certain date fields that need to be entered, and subsequent dates that follow in a timed interval. For instance, we set one date, the other needs to be 110 days prior. Another instance is 90 days past. How can I set those fields to auto-populate based off the entered dates?

[RuralGuy]

Those are calculated values and should not be in your table. Instead, create them with calculated fields in a query using the DateAdd() function.

[emccalment]

I apologize for my inexperience, but how would I do that. If I wanted to add say 90 days to an existing field, and have them both show up on a report. Would I add it into the format section of the properties? Or how does that work? Thanks

[RuralGuy]

You use the query builder to create the query. In the Field row (top row) of an empty column in the grid put: YourFieldName: DateAdd("d",-100,[YourOtherFieldName])
...using YOUR field names of course.