Hello,
I have a query. In the query I have two tables. One that pulls in the invoices and the amount of each invoice and the second table that pulls in the total amount of the invoices by account, the account total.
The problem I am having is when I run the query The account total duplicates itself on every line for each invoice and I only want it to show once for each account. How would I do this?
For Example, It looks like this:
Inv # Inv Amt. Acct # Total Acct. Balance
1 $12 1 $52
2 $14 1 $52
3 $26 1 $52
4 $34 2 $84
5 $40 2 $84
6 $10 2 $84
7 $33 3 $74
8 $25 3 $74
9 $16 3 $74
I would like it to look like this:
Inv # Inv Amt. Acct # Total Acct. Balance
1 $12 1 $52
2 $14 1 $0
3 $26 1 $0
4 $34 2 $84
5 $40 2 $0
6 $10 2 $0
7 $33 3 $74
8 $25 3 $0
9 $16 3 $0
How would I do this?
Thank you!
I have a query. In the query I have two tables. One that pulls in the invoices and the amount of each invoice and the second table that pulls in the total amount of the invoices by account, the account total.
The problem I am having is when I run the query The account total duplicates itself on every line for each invoice and I only want it to show once for each account. How would I do this?
For Example, It looks like this:
Inv # Inv Amt. Acct # Total Acct. Balance
1 $12 1 $52
2 $14 1 $52
3 $26 1 $52
4 $34 2 $84
5 $40 2 $84
6 $10 2 $84
7 $33 3 $74
8 $25 3 $74
9 $16 3 $74
I would like it to look like this:
Inv # Inv Amt. Acct # Total Acct. Balance
1 $12 1 $52
2 $14 1 $0
3 $26 1 $0
4 $34 2 $84
5 $40 2 $0
6 $10 2 $0
7 $33 3 $74
8 $25 3 $0
9 $16 3 $0
How would I do this?
Thank you!
