Duplicate values dropped in summing for total

C

CW

I have an invoice form and table that allows 5 lines to be entered with the
relevant separate services and amounts.
Then I have a Union query that collects the amounts together and sums the
amounts (GroupBy) to arrive at a total for the order.
If any of the amounts on the lines are the same, e.g. 25.00 appears more
than once within an invoice, the summing only includes one of them.
How can I correct this?
Many thanks
CW
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate vaules dropped when summing 5
Correct Nz syntax when summing? 4
VLOOKUP duplicate values in table the table array? Help me solve 1
sum values from selected items in multi-select listbox 2
How can I create a running yearly total for all of my invoices? 1
Calculate running total and print in footer/header 1
Summing visible controls only 4
Hide rows of one sheet based on values in another sheet? 2

Top