Sum without Group By

[Beorn]

Greetings Access Forum!

I have another question thats bugging me.
I have a table like this

Sim_Run\ Price, Number, Type 
1 50 1 A
1 100 3 B
1 150 5 C
2 200 2 A
2 250 3 B
3 300 1 A

(How to use this "TABLE" thing right)

Now i have a query1:
SELECT Sim_Run, Sum(Price*Number) AS Volume, Type
FROM table
GROUP BY Sim_Run, Type;

And a query2:
SELECT Sim_Run, Sum(Price*Number) AS Volume2
FROM table
GROUP BY Sim_Run;

But since table is very big opening it twice costs much time.




Im sure there is another way of doing this task. What i basicly want is just to add "sum(Volume) Group By Sim_run" into query1 than all would be finished.
But all the ways i tried i get an error.

All i want is tu sum up the "Volumes" for each Sim_Run despite the type.
But i also need the type and Volume data.

Any Idea?

Thanks in advance
Beorn

[weekend00]

if you really care about the time, you can save the result of Query1 into a table (group by sum_run,type) , then query2 sum this table for sim_run (group by sum_run).