TIME CALCULATION 1

[h11]

I have a query from which I am tyring to pull information from a total time field for anything greater than 30 minutes. Can some one tell me what the format would be thanks

SELECT [Tbl FAC].Date, [Tbl FAC].[Time In], [Tbl FAC].[Time Out], [Tbl FAC].user, [Tbl FAC].[total time]
FROM [Tbl FAC]
WHERE ((([Tbl FAC].[total time])<=Now()-#12/30/1899 0:50:0#));

 

[jrbarnett]

WHERE ((Minute([Tbl FAC].[total time]) > 30))

John

 

[SteveR77]

How is total time being calculated? If the total time is a numeric then I would recommend doing a comparison against 0.5 or 30.

But again this will depend upon how the time is calculated and stored.


HTH,

Steve

 

[h11]

JOHN this worked great, it return all times greater than 30 minuter. thanks

WHERE ((Minute([Tbl FAC].[total time]) > 30))