Calculating days from dates in querys

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a very simple access database, comprising of one
table for a work audit. I have 2 fields with dates in
them, one date a request received, and the other date a
procedure is performed. In the query I want both dates,
and also another field in the query that calculates the
time taken in days to perform the test. I have tried in
vain to get this to work, but cant, can anybody halp with
an expression I can use in the query???

Many thanks in advance

Chris
 
Back
Top