calcuate expressions in query

[Kate Fields]

I need to sum a group of records and define the criteria
for selecting the records to sum. Have no idea how to do
this. Help!

 

[Guido]

I'm not exactly sure what you are trying to do so let me
throw out some examples:

If you want to total all the sales by a certain person in
your query grid you would the sales field and the person
field then click the totals/group by button (Sigma) and
your query will then have a "total" row. Change "Group By"
to "Sum" for the sales field and leave "Group By" under
the person field. Now you can add your critera under the
person field to get just the person.

If you want to see all the sales but still need a total of
all sales at the end you need to remove the totals row and
you will need to do your totaling on a report.

If this doesn't help give me some more details of what you
are trying to do and I'll try and help.