donna wrote:

In design view of a query, I am trying to make a new field by subtracting one
field from another. Since the field to be subtracted is sometimes null, I
used this expression:

DUE: Nz(([SNESFee]-[INVOICE AMOUNT]),[SNESFEE])

The results are correct, but I can't change the way they are formatted. I
want it in currency format. It shows no dollar sign and no decimal places.

I tried to change the format to "currency" in the properties box. No good.
I tried to change the format to $#.00 and that's no good either.


That would happen if the result of the expression is somehow
being converted to a text string??

Your expression feels awkward to me. Try using:

Due: SNESFee - Nz(INVOICE AMOUNT], 0)

I don't see how that would make a difference, so, if it
still won't format try converting it back to a number.

Due: CCur(SNESFee - Nz(INVOICE AMOUNT], 0))

--
Marsh
MVP [MS Access]