Filter by value

[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?

 

[ghetto_banjo]

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

 

[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???

 

[ghetto_banjo]

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

 

[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.