Hi there,
I have four columns: date1, time1, date2, time2. All are strings.
I want to concatenate date1 & time1. Then date2 & time2.
Then I want to do the following calculation and the answer to expressed as number of days:
datetime2 - datetime1.
Please note: I am using MS Access 2007 and...