Sorting of records in Sub-Form problem?

[tim_tims33]

Hey guys,

I developed a simple Database for a local Vehicle Garage where the user types in the details of the work done to the motor in a subform. The main form is his customer details. When the mechanic wants to type in Labour Cost ... which he leaves as the last entry in the subform... the report messes up the order of which the details where typed in and the 'Labour record' is no longer at the bottom. The owner says that it is essential that the Labour record is printed at the bottom of the invoice report.

Does anyone know how to get this to occur... where the report prints out the details of the subform on the invoice printout the same as the order shown during Form View??

Would be hugely appreciated by me and the garage lads.

Cheers

 

[Simon_MT]

I would put a sequencer in the table you get Labour Costs and then you have control of exactly how the reports are formatted on the report.

Simon

 

[tim_tims33]

not sure what you mean here by sequencer...
sorry!

 

[tim_tims33]

Order of Records in Sub-Form

Still not solved! Can't seem to work out how to solve this problem (not sure what is meant by sequencer either?)

Anyone out there help?

Thanks

 

[Simon_MT]

The Table that contains Labour Costs put an additional Field lets say it called Sequence. Top Sequence 999 is on Labour Costs. On the Report include Sequence in the Sort. Providing nothing is higher than 999 Labour Costs will always come last.

Simon