ok so i two columns , one is type and the other is price. what i need to do is add everything up.
so instead of like many rows of computers and their costs i need like said computer and the total sold are $346488 for example
note i havent done this before and i watched a youtube tutorial on query calcs so it has put it in perspective a little bit but his was item*qty where as mine isnt, mines like
expID exptype expDept exp amount expdate
01 pc1 adm $960 3/3/09
02 pc200 adm $500 4/4/9
03 pc1 adm $600 5/5/9
so its like whatevers in adm is using or bought more than 1 pc1 at different prices. where as i am looking at doing a total for all the pc1s that were bought on differnet dates and diff amounts. but not qty. so when i make a new field for example total:[expamount*exptype] i get parameter value and the exp amounts just in a new field .
so to me it should be like for pc1 the new field should be saying its 960+600 =1560
then i have to export it all to excel. but part of the assesment is to ""Calculate a sum on groups of identical expense types. The query should display the total expense for Computers, the total expense for Software and so on.""
so can anyone help me out lol. im a bit confused.