Hi guys,
I have this field set up in my query:
SP STG: IIf([Cur]="EUR",[Selling Price]*0.6998)
Basically if the Customer currency is EUR then convert to GBP (Sterling)
However, some customers currency is GBP and so I want to add this in so that no calculation is performed i.e. Only currencies in EURO are converted to sterling.
SO I need some sort of statement like If Cur= EUR *0.6998, If Cur= GBP do nothing..
can I do this within one field?
Thanks for your time guys
I have this field set up in my query:
SP STG: IIf([Cur]="EUR",[Selling Price]*0.6998)
Basically if the Customer currency is EUR then convert to GBP (Sterling)
However, some customers currency is GBP and so I want to add this in so that no calculation is performed i.e. Only currencies in EURO are converted to sterling.
SO I need some sort of statement like If Cur= EUR *0.6998, If Cur= GBP do nothing..
can I do this within one field?
Thanks for your time guys