I can't take it anymore! Ok here's the problem. I have a database with three tables. Vendors, Contracts and Payments. I need to keep track of payments made to each contract by the account number. I've set up a form for the contracts that includes a sub-form for the payments. I want to be able to pull the total payments for each account number out of the sub-form. I've tried using the Dsum function but it doesn't seem to work. I either get the first account number used or an error. Should I be setting up another table for the account numbers? I would really appreciate any suggestions!
Thanks!
Thanks!