Rounding and Formatting Issues

[billgyrotech]

I would greatly appreciate some help on a couple of issues:

1. Workorders by Customer subform is not calculating properly:


The currency is rounding (how to prevent this) so the result is not the same as on the Workorder and the Amount Due is blank.

2. When opening the Workorder on the heading it shows the WorkorderID not formatted as 5 digits like on the field WorkorderID. I would like to show it as 5 digits.

Thank you very much for any suggestions,
billgyrotech

[apr pillai]

Database is attached after the requested change.

[billgyrotech]

I tried to open the Workorder by using the command button and I get error message the save isn't available now. Also, when opening it says read only. Do you know why?

Thanks,
billgyrotech

[apr pillai]

I have compacted the database under Access2007 for reducing its size, may be that is the reason.

Database after change is attached. This time the database is not compacted.