create a calculation from fields in different records

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

Guest

Am using access 2000.
I need to work out the number of days i have a document before passing it
on. The received date is on 1 record and the date sent is on another. Is
there an easier way of working out the days without having to add another
field on the same record
Thanks
 
The best way is an In & out date on the same record. Do you have some common
identifier in the two records like Rental Invoice?
You can put the same table in the query twice. Access adds a suffix of _1
to the second instance of the table. Then join the two on the field that has
the common identifier. Then you have access to both dates.
 
Back
Top