Comparing Dates between records

C

Cathy Maxin

How do you calculate the date difference (of course I need
work days) in the same field of different records?
 
J

John Vinson

How do you calculate the date difference (of course I need
work days) in the same field of different records?
Click to expand...

By creating a Self Join query, adding the table to the query design
grid *twice* and joining the two instances by some appropriate field
(which, of course, I don't know since you didn't describe the table);
then use the suggestions at

http://www.mvps.org/access/datetime/date0012.htm

to calculate the date difference.
 
Top