In Query remove $ sign

  • Thread starter Thread starter andy
  • Start date Start date
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
 
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
 
Back
Top