I have set up a project in which i take in deposits for several jobs and then charge labor from 4 different shops against each job.this is much like a check book that tracks several accounts at one time. my problem is getting current balance info.deposits are input to a table, balances totaled with a query, labor costs are totaled with another query. i want to list each job # and the total $ deposited minus the total labor$. i tried to create a report but for some reason kept getting a "record locked " message. thanks ahead of time.
