I think this is simple...

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.

.