Access time help

[mercmannick]

Nick, actually the best way is to use VBA with a recordset when the data is actually being entered.
You open the table with the same Roll No., if there are records then you know it is the same roll and you Increment the Time based on the (set hours) if there are no records you know it is a new Roll.

My Son Works at Corus Trostre Plant.

HeHe we supply to him then

how would i do this OBP , as currently i have table FN Routes which has fields:
1.File No
2.Sort Order
3.opref
4.OP Desc
5.Est Hours

i have another table WC which has fields:
1.opref , which is linked to field 3 FN Route
2.OP Desc
3.WC

i have another table SQL Man Plan which is all current live orders has fields:
1.Roll No 2.Customer 3.Wo Ref 4.Grade 5.Status 6.Operation 7.Cast Date 8.Due Date 9.Man Targ 10.Weight 11.Area 12.Delivery Term 13.Value 14.
Week No 15.CW Drg 16.Cw Rev 17.File No , which is linked to 1.File No on FN Routes 18.barrel diameter 19.barrel length 20.overall length 21.F7 22.Profit 23.S/C


i use these to create a days schedule ,

Thanks Nick