I think this is simple...

[Shimshee]

I have a table that looks like this.....

ORDER SHIPCOST
1 $3.00
1 $1.15
2 $1.00
3 $2.50
4 $3.50
4 $2.00

I want a query that will give me the totals per order so it would look
like this,
1 $4.15
2 $2.00
3 $2.50
4 $5.50

As you can see I'm new to this and I thank you for your help.

 

[Rick Brandt]

I have a table that looks like this.....

ORDER SHIPCOST
1 $3.00
1 $1.15
2 $1.00
3 $2.50
4 $3.50
4 $2.00

I want a query that will give me the totals per order so it would look
like this,
1 $4.15
2 $2.00
3 $2.50
4 $5.50

As you can see I'm new to this and I thank you for your help.

In the query designer pull down the fields ORDER and SHIPCOST from your table.
From the main menu choose...

View
Totals

This will cause a new row (Total) to appear in the designer grid. Under ORDER
leave the default entry for Total of "Group By". Under SHIPCOST choose "Sum".

That's it.