Hi Jackle,

The only way I can think of achieving this is to create a temporary table
and then drive the datasheet or form off the table - as you know it's easy in
Excel to make a formula in one cell refer back tio the cell in the row above,
but there's no way that I've discovered to do the same in an Access table,
datasheet or continuous form. (And also you can't have a continous subform
within a continuous form, so there's another solution out of the window!!).

Now the only problem with creating a temporary table to achieve your planned
layout is this: if you want to add new records or edit existing ones it gets
quite complex! How good are you with VBA and either ADO or DAO?

I did briefly toy with another idea (two fields for part#, inputting to one,
with code to copy from 'field 1' to 'field 2' and then deleting from 'field
1' if another record already had that value) but the correct sorting of WO#
within each Part# section would only work if the first time you used a new
part# was always going to be the time with the lowest WO#, if you see what I
mean. Rats!!

I realise this doesn't answer the question, but if you want me to follow up
any of these ramblings please let me know.