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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dcount returning no results!!! 0
Calculate difference of 2 dates in same field but different record 1
Comparing two fields in two different records 6
Date calculation on 2 fields 5
Compare dates in two seperate records 7
Group by query question 1
Creating Reoccuring Event Records 3
Calculated field 5

Back
Top