OK my first post here so I hope I get some nice help from ya'll
I have been making a database (in access) to track emails at work. It basically needs to track when the email was recieved, when it was replied to and the turnaround time.
I have done the first two bits (Date Recieved and Date Completed) but making it report on turnaround time is doing my nut in !!
Does anyone know of a way to figure out the turnaround time using two dates and present this in a report. Maybe some sample code to look at or just some suggestions? Ive spent hours trying to solve this (lame I hear you say ) Well I dont claim to be an Access guru, in fact Ive only just started using it really !
If anyone can give me some pointers or even a hand... please
Pardon my ignorance, but is turnaround time the difference between the 2 dates? If yes, look at the function DateDiff, here is a brief example, you can use it with time, date, days, hours and seconds. You can use it in SQL also:
Dim date1 As Date
Dim date2 As Date
date1 = "10:00:00"
date2 = "12:30:00"
'return the number of minutes of difference (150)
'the first parameter is the "interval"
' n for hour, m for months, d for days, h for hours
MsgBox DateDiff("n", date1, date2)