How do I print a report without showing any zero fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i HAVE A FORM THAT HAS CALUCATIONS THAT IN ORDER TO TOTAL, SOME INSTANCES
REQUIRRES A "0" BE ENTERED WHEN THERE IS NO VALLUE IN ORDER FOR FORM TO
TOTAL. I DO NOT WANT THIS "0" VALUE TO PRINT ON MY REPORT, HOW DO I FORMAT
REPORT TO ONLY PRINT WHEN THERE IS A NUMERIC VALUE NOT WHEN "0"
 
Exclude them from the data source (the query).

Your report should be based on a query. Just put criteria in to say >0 or
not null.

Rick B.
 
Please find and turn off your CAPS LOCK. Use your shift key.

Do you want to filter out records with 0 or do you want to display a blank
or nothing where there is a value of 0? If you want to simply adjust the
formatting, use the format property. Check Help on formatting numbers to see
how to do this.
 
The value is on the form only, i have three fields I enter dollar amounts in,
which calucates a total, the expression in the form for the total calculation
requires a number in each of the three fields in order to total, so if there
is no number for the field i must enter a zero to have it calculate a total.
I do not want these zero entries to show on my report which is set to print
automatically from this form.
 
DURASEAL,
did you try my earlier suggestion?


see below, it should work for what you need
KB
 
Sometimes I feel like I am talking to either my kids who don't listen or to
my dad who doesn't hear well. I try to be nice to them all so again I will
ask:

Did you check Help on format settings for numeric values?
 
I am sorry, I seem like such an idiot to you, I am trying, and yes I did
check Help on format settings for numeric values
 
Do I have to ask if you found anything useful to solve your problem or if
you understand what you found or if you are still struggling with display
zero values as blanks?
 
Back
Top