How to get multiple records to show as one

[accessiscool]

Hi there,

I have a query which is supposed to show the revenue from each advertising source.

PLease see attached in zip file (cant post pics b/c I have less than 10 posts)

As you can see it has revenue amounts for the same source of advertising:


Radio has two amounts, INternet has two etc..


What can I do to only have each form of advertising show up once?

and the revenue amounts summed up for each advertising medium.

Thank You

Natasha

 

[bob fitz]

Create an aggregate query. See: http://www.599cd.com/tips/access/aggregate-query/

 

[Monardo]

And this is the SQL

SELECT [How they heard a...], sum(Revenue) as SumRevenue
FROM [Revenue per car purchased] 
GROUP BY [How they heard a...]

You need to change [How they heard a...] and also table name [Revenue per car purchased] if different.