databasedesigner18
New member
- Local time
- Today, 02:22
- Joined
- Oct 10, 2018
- Messages
- 6
Hi.
I have created a database to track invoices across many different contracts. Each contract has multiple tasks over at least 3 or 4 years. Each task under a contract has invoices that are submitted for payment. Each invoice(attached to a contract and specific task, has the same Contract/task#, Dept, and Description. They differ only in Net Amount,which is the gross dollar amount less retainage amount.
I am trying to combine(& sum) all the net amounts of invoices that share the same contract/task combo.
I hope this is not confusing
I have created a database to track invoices across many different contracts. Each contract has multiple tasks over at least 3 or 4 years. Each task under a contract has invoices that are submitted for payment. Each invoice(attached to a contract and specific task, has the same Contract/task#, Dept, and Description. They differ only in Net Amount,which is the gross dollar amount less retainage amount.
I am trying to combine(& sum) all the net amounts of invoices that share the same contract/task combo.
I hope this is not confusing