Simple Calculation Question

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.
--
Johnny

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

On Feb 14, 2:02 pm, Johnny wrote:
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.
--
Johnny

Johnny wrote:

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.


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

--
Marsh
MVP [MS Access]