boaterjohn
Registered User.
- Local time
- Today, 10:30
- Joined
- Nov 16, 2012
- Messages
- 10
I have a query that has 4 fields.- " Date, CarNo, TimeStopped and TimeDifference.
The query is filtered useing the "[Enter Date]. The "TimeStoped" field and the "TimeDiff" field are short time format. An example of what my select qry looks like:
RecNo Date CarNo TimeStopped TimeDifference
1 02/25/2013 1 09:15 1st time needszero
2 02/25/2013 1 09:30 rec2-rec1
3 02/25/2013 1 10:00 rec3-rec2
4 02/25/2013 2 09:15 1st time needszero
5 02/25/2013 2 09:30 rec5-rec4
6 02/25/2013 2 09:45 rec6-rec5
and so forth.
I need to calculate the "TimeDifference" field. I know I need a recordset for the query and some sort of looping code. I'm pretty green in this coding. If anyone can give me some help; I really thank you.
boaterjohn
The query is filtered useing the "[Enter Date]. The "TimeStoped" field and the "TimeDiff" field are short time format. An example of what my select qry looks like:
RecNo Date CarNo TimeStopped TimeDifference
1 02/25/2013 1 09:15 1st time needszero
2 02/25/2013 1 09:30 rec2-rec1
3 02/25/2013 1 10:00 rec3-rec2
4 02/25/2013 2 09:15 1st time needszero
5 02/25/2013 2 09:30 rec5-rec4
6 02/25/2013 2 09:45 rec6-rec5
and so forth.
I need to calculate the "TimeDifference" field. I know I need a recordset for the query and some sort of looping code. I'm pretty green in this coding. If anyone can give me some help; I really thank you.
boaterjohn