Format and Calculate on same field in Query

[Westley via AccessMonster.com]

I have a query with field named: amtpaid
I calculate this field to be amtpaid:[invamt]-[otheramt]
It gives me the calculated amount in this field, but the number is showing
$sign

How do i remove the $sign from this calculated field?

I know how to format the field with Expr2:Format([amtpaid],"000.00") But not
sure how do do both format and calculate in the same field.

I also, tried to split the field to format in one field and calculate in the
other, but the problem with that is that i need only the one field to show up
in my query.

Please help....

Thanks,
Westley

 

[fredg]

I have a query with field named: amtpaid
I calculate this field to be amtpaid:[invamt]-[otheramt]
It gives me the calculated amount in this field, but the number is showing
$sign

How do i remove the $sign from this calculated field?

I know how to format the field with Expr2:Format([amtpaid],"000.00") But not
sure how do do both format and calculate in the same field.

I also, tried to split the field to format in one field and calculate in the
other, but the problem with that is that i need only the one field to show up
in my query.

Please help....

Thanks,
Westley

If you always want the format to be 000.00, then
amtpaid:Format([invamt]-[otheramt],"000.00")

Otherwise use:
amtpaid:Format([invamt]-[otheramt],"#0.00")