Filter by value

A

acss

I have the expression Sum([InvAmt]*0.03) that applys to all records in the
query. How do i get the expression to only apply to (InvAmt) of CHINA?
 
G

ghetto_banjo

if you have another field, perhaps called [country], you would put
criteria "CHINA" for that field.
 
A

acss

There already exists a VendorCtry field where this and three other values
reside, china, brazil, argentina,peru. I am trying to have the expression
perform the calculation on only one country and that is why the expression to
show results for the records of china only. Is there a way to do this???
 
G

ghetto_banjo

make the criteria for the VendorCtry field set to "china", then it
will only use those records set to china only.
 
A

acss

This query will be used on a report so the four countries must appear and the
totals for each country. I need the country of china to have the totals
appear yet minus the percentage.
 
Top