find total question

[Guest]

i have a db where i enter exp for overseas patients. there is one field for f
currency amount , one field for currency code.and a third field for equiv amt
in local curr.

i have one field to find total i.e.=Sum([fcamount]) (these are a fields in
the subform)

for each patient , there should be some amounts in local curr.so , i will
enter like this
fc amt curr euiv amt(local)
500 usd 250

if amt is in local curr
fc amt curr equiv
500 kwd 500

but for the calculation of total of fc amount, i want it to exclude any
amount with the local curr code. how can i do this formula =Sum([fcamount]) ?

i am taking this to the main form by this thru a control on the main form
like this : =IIf(IsError([Patients Subform].Form!FCAMT),0,[Patients
Subform].Form!FCAMT)
but this will give total amount entered in the field f curr.i want it to
exclude those with local currency code items. need your help please

 

[Guest]

it ok . i have tried creating a new query and set it filtered to currency
codes other than local curr.and used this query to creat another subform ,
and from there can get what i want .