C Cathy Maxin Sep 30, 2003 #1 How do you calculate the date difference (of course I need work days) in the same field of different records?
How do you calculate the date difference (of course I need work days) in the same field of different records?
J John Vinson Sep 30, 2003 #2 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.
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.
