Grouping and Addiing using Query Builder

[GAccess]

This question is for access 2010 :



I have TableA

Car Car Type Limited Test Miles Miles Driven
Toyota Camry 1000 400
Toyota Corolla 1000 10
Toyota Prius 1000 6000
Ford F150 600 100
Ford F250 600 50
Chevy Malibu 100 50


I want a query to populate this

Car Limited Test Miles Miles Driven
Toyota 1000 6410
Ford 600 150
Chevy 100 50

In words.. I would like to get a total of test miles driven in each car brand (i.e Toyota, Ford, Chevy). For instance, Toyotas will add up all test miles for Camry, Corolla, and Prius as Ford will add up all test miles driven for the F150 and F250.

Will anyone know how to do this by using query builder? I want to setup through SQL.
Been working on this for 2 days, and I am getting the wrong sum totals.

I have grouped by Car and summed up miles driven in my query builder.

I thought this was easy... but its proving to be a hassle

[GAccess]

Anybody?

[orange]

Try

SELECT Car, Sum([Miles Driven])
From TableA
Group By Car

[ketbdnetbp]

GAccess - In your query, you could try...
Car, Group By
LimitedTestMiles, MAX
MilesDriven, SUM

the SQL would look something like...

SELECT DISTINCTROW tblCar.Car, Max(tblCar.LimitedTestMiles) AS [Max Of LimitedTestMiles], Sum(tblCar.MilesDriven) AS [Sum Of MilesDriven]
FROM tblCar
GROUP BY tblCar.Car;

Change name(s) of table and fields accordingly.

Hope this helps,

Jim

[ketbdnetbp]

Sorry Orange, didn't see your reply before posting. Jim