putting a Zero in a field (count of) instead of a blank...

  • Thread starter Thread starter Bryan
  • Start date Start date
B

Bryan

I have a report that has several columns, some of which will be zero.
(how many of this type of sale was paid for by credit card, etc).

How can I have the report print a zero in that column instead of just
leaving a
blank there?


Thanks in advance,

Bryan
 
Hi Bryan.
You could place someting like:
=IIF([YourCreditCardField] is null,"0",
[YourCreditCardField])
all on one line in the source field.
Hope this helps.
Fons
 
Thank you!

I was looking in the formatting and other properties to find the answer to
this,
but apparently it has to be done like you suggest.

Thanks again,

Bryan

Fons Ponsioen said:
Hi Bryan.
You could place someting like:
=IIF([YourCreditCardField] is null,"0",
[YourCreditCardField])
all on one line in the source field.
Hope this helps.
Fons
-----Original Message-----
I have a report that has several columns, some of which will be zero.
(how many of this type of sale was paid for by credit card, etc).

How can I have the report print a zero in that column instead of just
leaving a
blank there?


Thanks in advance,

Bryan


.
Click to expand...
Click to expand...
 
Thank you!

I was looking in the formatting and other properties to find the answer to
this,
but apparently it has to be done like you suggest.

Thanks again,

Bryan

Fons Ponsioen said:
Hi Bryan.
You could place someting like:
=IIF([YourCreditCardField] is null,"0",
[YourCreditCardField])
all on one line in the source field.
Hope this helps.
Fons
-----Original Message-----
I have a report that has several columns, some of which will be zero.
(how many of this type of sale was paid for by credit card, etc).

How can I have the report print a zero in that column instead of just
leaving a
blank there?


Thanks in advance,

Bryan


.
Click to expand...
Click to expand...
Click to expand...

Bryan,
Actually, your question is misleading.
Having a 0 in a field is NOT the same as as a Null in that field.
A 0 is a valid number and will print 0.
If the field is in fact Null, then your original assumption of using
the format property is good.

Set the Format property of the control to:
#;-#;0;0
See Access help regarding
Format Property + Number and Currency datatype.
 
I have a question along these same lines. I have a field
that is set up as currency. Is it possible to have the
field be blank on the report if a figure hasn't been
entered?
Samantha
-----Original Message-----
Thank you!

I was looking in the formatting and other properties to find the answer to
this,
but apparently it has to be done like you suggest.

Thanks again,

Bryan

Hi Bryan.
You could place someting like:
=IIF([YourCreditCardField] is null,"0",
[YourCreditCardField])
all on one line in the source field.
Hope this helps.
Fons
-----Original Message-----
I have a report that has several columns, some of which
will be zero.
(how many of this type of sale was paid for by credit
card, etc).

How can I have the report print a zero in that column
instead of just
leaving a
blank there?


Thanks in advance,

Bryan


.
Click to expand...
Click to expand...

Bryan,
Actually, your question is misleading.
Having a 0 in a field is NOT the same as as a Null in that field.
A 0 is a valid number and will print 0.
If the field is in fact Null, then your original assumption of using
the format property is good.

Set the Format property of the control to:
#;-#;0;0
See Access help regarding
Format Property + Number and Currency datatype.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top