sum the currency sort

[fishqqq]

I have a form with two fields [sell rate] and [sell rate currency]
at the footer of the form i have two fields [total cdn] and [total usd]

Can someone show me the proper format for the control fields of [total
cdn] and [total usd] so that they sum all the [sell rate] for the
correct currency?

your suggestions are greatly appreciated.

 

[Marshall Barton]

I have a form with two fields [sell rate] and [sell rate currency]
at the footer of the form i have two fields [total cdn] and [total usd]

Can someone show me the proper format for the control fields of [total
cdn] and [total usd] so that they sum all the [sell rate] for the
correct currency?

If the [sell rate currency] field contains either "cdn" or
"usd", then you can use the [total cdn] text box can use the
expression:
=Sum(IIf([sell rate currency] = "cdn", [sell rate], 0))

 

[fishqqq]

worked perfectly, thanks