In Query remove $ sign

[andy]

Data from table has $, and decimal. I would like to have a
query item that is formatted without the $ sign.

Data looks like this

$78.44
$177.09

I want it to look like this

78.44
177.09

Thank you in advance
God bless you
andy

 

[Hilary Ostrov]

Data from table has $, and decimal. I would like to have a
query item that is formatted without the $ sign.

Data looks like this

$78.44
$177.09

I want it to look like this

78.44
177.09

In your query, right-click on the field name, then select
"Properties". In the Field Properties window, select "Fixed" from the
"Format" dropdown, and make sure the "Decimal Places" is set to 2.

HTH

hro