Comparing value in a time format to an integer that represents seconds

[inso18]

Hello.

I'm very much interested in putting a criteria into a query that will show only the values that are bigger than an integer number of seconds (for ex. 12) The time values field that is being compared is in 00:12 format (minutes:seconds)

I cannot compare time to an Interger number.

Maybe I can convert the integer number into time format and than compare it somehow with the time values from the field?

Advices?

Regards, inso18

 

[PHV]

If the time field is of type DateTime with no date value:
NumberOfSeconds: Int(TimeField*86400)

If the time field is of type DateTime with the date value:
NumberOfSeconds: Int((TimeField-Int(TimeField))*86400)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886