Simple Calculation Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've done this before, but can't recall how, it's been awhile.

I have multiple duplicate lines containing same customer name in one column
and in the other column are pricing information. The reason they show as
duplicate name is due to the pricing differences in each line or the pricing
dates being different.

All I want to accomplish is a grand total pricing for each customer as my
final outcome. I need to do this preferrably in a query.

Thanks for any suggestions.
 
Click the Sigma (Totals) button in the toolbar in query design mode.
This adds teh totals row to your query. Instead of "Group By" for
your pricing field choose "Sum"

Cheers,
Jason Lepack
 
Johnny said:
I've done this before, but can't recall how, it's been awhile.

I have multiple duplicate lines containing same customer name in one column
and in the other column are pricing information. The reason they show as
duplicate name is due to the pricing differences in each line or the pricing
dates being different.

All I want to accomplish is a grand total pricing for each customer as my
final outcome. I need to do this preferrably in a query.
Click to expand...


Use a Totals type qurery (View menu in query design window).
 
Back
Top