Filter by value

  • Thread starter Thread starter acss
  • Start date Start date
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?
 
if you have another field, perhaps called [country], you would put
criteria "CHINA" for that field.
 
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???
 
make the criteria for the VendorCtry field set to "china", then it
will only use those records set to china only.
 
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.
 
Back
Top