Formatting Zero Value $ fields in a report

[John Baker]

Hi:

I have a report that has currency fields which I wish to have as blank if they are zero,
but to show as fill currency if they have data in them:

0 = Blank
100= $ 100.00
..01 = $ .01

I know I can use # to create blank, but have not been able to figure out how to deal with
the set up of the dollar sign and decimal point. Advice appreciated!

Thanks in advance

John Baker

[Tom van Stiphout]

On Tue, 16 Nov 2004 13:14:58 GMT, John Baker <Ba******@Verizon.net>
wrote:

Format your value using the Format function.
-Tom.

Hi:

I have a report that has currency fields which I wish to have as blank if they are zero,
but to show as fill currency if they have data in them:

0 = Blank
100= $ 100.00
.01 = $ .01

I know I can use # to create blank, but have not been able to figure out how to deal with
the set up of the dollar sign and decimal point. Advice appreciated!

Thanks in advance

John Baker

[Keith Wilby]

John Baker <Ba******@Verizon.net> wrote:

I have a report that has currency fields which I wish to have as blank
if they are zero, but to show as fill currency if they have data in
them:

0 = Blank
100= $ 100.00
.01 = $ .01

Hi John.

How about doing this as an in-line 'If' in the report's query? I'm assuming
that the field's data type is 'currency' in the table.

MyCurrencyField:IIf([MyField]=0,Null,[MyField])

HTH - Keith.
www.keithwilby.com

[fredg]

On Tue, 16 Nov 2004 13:14:58 GMT, John Baker wrote:

Hi:

I have a report that has currency fields which I wish to have as blank if they are zero,
but to show as fill currency if they have data in them:

0 = Blank
100= $ 100.00
.01 = $ .01

I know I can use # to create blank, but have not been able to figure out how to deal with
the set up of the dollar sign and decimal point. Advice appreciated!

Thanks in advance

John Baker

Use the control's Format property.
$ #,##0.00;-$ #,##0.00;
See Access Help.
Format property + Number and Currency Datatype
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.