formatting issue?

[fishhead]

HI there,
i have a continuous form that has totals in both CDN and USD

In the form footer I have two txt boxes that sum each type

For some reason the format of the Control Source doesn't seem to work any longer.

here's what I'm using:

=Sum(-[SumOfOutstanding]*([CURRENCY]="CDN"))

where [sumofoutstanding] = the field that has the separate line items in either CDN or USD



Can anyone tell me how I might change the expression to sum these two items separately?

thanks in advance...

[ranman256]

you cannot sum words like "CDN"

You can use it as criteria:
=Dsum([field],[tbl/qry], "[currency]='CDN'")

[CJ_London]

Is currency displayed on your form as a column called currency with text values?

Not sure what you mean by ‘format doesn’t seem to work’. Provide some examples to illustrate what you mean