Recent content by xChase

Oh thats great, thanks :D. Now this is probably a silly question, but how do I make the output appear in $? Like $4504.00

I have three columns: ExpType, ExpDepartmentID and ExpAmount. Inside the ExpType there are various values, some of which are Stationery, some are Computers etc. What I need to do is to grab all the values that are Stationery, and add them all together in one query, and then do the same for...