pulling from tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

use a totals query, return the Max of your date, then create another
query based on that and do your date math with DateAdd.
 
Back
Top