Duplicate values dropped in summing for total

  • Thread starter Thread starter CW
  • Start date Start date
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
 
Back
Top