I got hammered with work and home stuff. Lost you for a while.

A) Most if not all of my effort has gone into building my tables so it's not so obvious I'm more accustom to Excel.
Look again at the dB in Post #4. Look at the subform. When you go to the store to buy bread, milk, cereal and bananas, are all items on the same line?

So why should your services be on the same line (record)??? Each service should be in its own record, just like the store receipt.




4) Loud and clear to not use calculated fields in a table. Where is it best to do my calculations. I have had a difficult time finding information on this.
You can use the form before update event to have VBA calculate the amount.