In Query remove $ sign

A

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
 
H

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
Click to expand...

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
 
Top