Greetings Access Forum!
I have another question thats bugging me.
I have a table like this
Code:
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