Calculating inside queries..

[xChase]

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 Computers, in the same or in a different query.

Any help?

 

[evanscamman]

Piece of cake.

Set the criteria for your ExpType to be the value you want.
You can either do three different queries, or perhaps point it to a field on your form and let your user choose which value.

Click on the totals button to show the totals row. For ExpAmount, instead of 'Group By' change it to Sum.

This should do it!

 

[xChase]

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

 

[JANR]

but how do I make the output appear in $?

Got to the format property of the field in question and select Currency IF your default regional settings is in $

If not type this in the format property if you want thousand seperator

$# #00

or if you just want $4526

$00

You can then set the desimal property if you want cents

JR