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
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
ateDif("d",[received],[procedure])