I have a form with a txt field with the control property set as follows:
=([customer] & " " & [amt] & " " & [curr] & " " & [date])
This is returning a result as follows:
ABC Copmany 307.0323 CDN 7/15/16
Can someone suggest how i would format this to return a result as ......$307.03...... instead of 307.0323?
I set the underlying query amt format to currency but this doesn't make any difference. I'm at a loss now?
thanks in advance.