Get rid of Currency Decimal places

[Huber57]

Hello all:

I have researched Format and cannot find the answer to what a question that
probably has a simple solution.

I have a report that shows a contract value. In the table where the data is
stored it is a currency data type set with 0 decimals. On the report is
shows "$100,000.00".

I want it to show "$100,000". Any help on this?

I am using MS Access 2003 and the report is bound to a query.

Thanks!

 

[Allen Browne]

Try a Format like this:
" $#,##0;-$#,##0"

 

[Huber57]

Thanks much. Worked perfectly.

Try a Format like this:
" $#,##0;-$#,##0"