Report problem re. amt. column

  • Thread starter Thread starter BCS
  • Start date Start date
B

BCS

Hi - I've generated a 'report' and one column is an amount field. I notice
that some of the amounts have the $ sign and some do not. Is this an easy
fix? I want $ signs for each amount. What am I missing (I am new to Access)
as I wasn't able to research an answer to this problem.

Thanks for any help!
 
Is the 'amount' field a calculated field? If yes, are you explicitly
formatting the data in that field? What is the expression for the calculated
field?

If it's not a calculated field, is it coming from a single table? Or is it a
field from a UNION query?

Are you using the Format property for the text box in the report in which
you display this value? Use the Format property to have the $ show up for
all values:

$#,##0.00;-$#,##0.00
 
Back
Top