Show zero balance on report

  • Thread starter Thread starter Dennis Hansen
  • Start date Start date
D

Dennis Hansen

My report counts records assigned to an item, I am only
interested in the total records per item. If the item has
no records assigned to it, the item doesn't show on the
report, and I would like it to. I would like to see the
item listed even if it has a 0 balance
How can I make this happen?
Dennis Hansen
 
My report counts records assigned to an item, I am only
interested in the total records per item. If the item has
no records assigned to it, the item doesn't show on the
report, and I would like it to. I would like to see the
item listed even if it has a 0 balance
How can I make this happen?
Dennis Hansen
Click to expand...

As the Format Property of the control, write:
#;-#;0;0

Look up in Access Help:
Format Property + Number and Currency datatypes

Or you could use an expression in an unbound control:
=Nz([FieldName],0)
 
-----Original Message-----
My report counts records assigned to an item, I am only
interested in the total records per item. If the item has
no records assigned to it, the item doesn't show on the
report, and I would like it to. I would like to see the
item listed even if it has a 0 balance
How can I make this happen?
Dennis Hansen

.I'm using a count control =count(*) in my report for
Click to expand...
the information I need. If there are no records to count
it will not show the description of what I am counting, I
need to show the description on my report. And show a zero
balance; it would even be nice if actually said "zero
balance"
I tried to format as you mentioned earlier, every control
in my report even some in the query
The query for this report is from another query, could
this be my problem?


Group header
Desc =count(*)

Section detail Property visible NO

Item Id another
field another field

Thank you
Feeling a little stubpid now
Dennis Hansen
 
Back
Top