Compare Time feilds.

[David Ehrenreich]

Hello,

I have made a database for a testing center I work at.
We have students that login in to a form for their test's
and then a form for us to put in test details. I would
like to make a query that compares two times and displays
when one time is greater then the other.

I have two feilds that log the time. the first feild
TimeIn logs when a student has signed in. The second,
Allowed logs the time the student has to be finished. So
when Allowed is greater than Timein it would query those
results.

How do I do this?
Any help would be great.

David Ehrenreich

 

[[MVP] S. Clark]

Hello,

I have made a database for a testing center I work at.
We have students that login in to a form for their test's
and then a form for us to put in test details. I would
like to make a query that compares two times and displays
when one time is greater then the other.

I have two feilds that log the time. the first feild
TimeIn logs when a student has signed in. The second,
Allowed logs the time the student has to be finished. So
when Allowed is greater than Timein it would query those
results.

How do I do this?
Any help would be great.

David Ehrenreich

 

[[MVP] S. Clark]

[Sorry for the first reply, which was empty]

I would think that you want to do in the code of the form, but since you
posted to the query section, I'll assume that you want to see SQL.

The following will take the start time and add 30 minutes.
Select [StartTime], [StartTime] + #00:30# as EndTime from table1


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-