Recent content by rjacko10

Hi Plog, You're right, I'm working with someone else's construction (a database via ODBC), the data is stored incredibly inconveniently. But I need the time field because I am looking for decimal points (I need to be precise.. clinical research). Your help was great. Thanks. From that I...

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...