I want to calculate a field, from two different tables. It will auto
calculate a date based on a past date (from a log table). How can I write a
formula using a controlsource.

For instance I want to take the most recent date from the datelog and add to
it using an interval(the interval is in another table) to calculate my field
into a different table. What would be the formula ?

I know if I was workign within the same table this wouldn't be a problem but
how to I pull information from certain fields do I use an
![tblLog]![Fieldhere]? or do I use quotations?

thank u