Totals and Running totals

[psy]

OK. I'm new to Access and have been trying to create a database. I have most of what I want so far, but I have hit a stumbling block. I have totals of each invoice. I need to keep a running sum of all invoices per campus. Then I need to be able to deduct that from their account balance. I am not sure how to do this. When I try a report, I can't get the Order Totals to show up. The Order Total column only shows zero's. Would anybody mind taking a look at what I have and seeing if they could point me in the right direction? I know that there is probably a lot wrong with the database, but I will take any help that is offered.

 

[Rich]

Post a zipped 97ver, someone will take a look for you

 

[psy]

Rich,
It's too large to post.

Pat,
The subtotal is queried and then accessed by a calculated field. When I add items, the total changes appropriately. What I am looking to do is, while in form view, be able to see the order, the total of the order, and the remaining balance in the spending budget. I have the order and the total of the order taken care of. All I lack is seeing the remaining balance.

I know that my database is probably very poor. I have only begun working with Access. I am also finding it difficult to create correct reports with the way the database is set up.

Thanks,

Psy