Zero values in query

's Computer Specifications

Hello,

My query runs great but i have zero values appear in some coulmns.How do you
remove the zeros?
Thanks

's Computer Specifications

Can you provide any hint as to what you mean by "remove the zeros"?
White-out?

Do you want to filter out records? Do you want to change 0 to null?

--
Duane Hookom
MS Access MVP

"jk" <(E-Mail Removed)> wrote in message
news:985803FD-BE39-44E8-A0F9-(E-Mail Removed)...
> Hello,
>
> My query runs great but i have zero values appear in some coulmns.How do
you
> remove the zeros?
> Thanks

's Computer Specifications

Hello Duane,

The zeros that appear also appear on reports as well as query and they do
not affect the totals.I am looking to remove them so they dont show up so if
there is something that whites them out or any other method, please advise on
the most practical way.Much thanks for your support.

"Duane Hookom" wrote:

> Can you provide any hint as to what you mean by "remove the zeros"?
> White-out?
>
> Do you want to filter out records? Do you want to change 0 to null?
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "jk" <(E-Mail Removed)> wrote in message
> news:985803FD-BE39-44E8-A0F9-(E-Mail Removed)...
> > Hello,
> >
> > My query runs great but i have zero values appear in some coulmns.How do
> you
> > remove the zeros?
> > Thanks
>
>
>

's Computer Specifications

You can use conditional formatting in the report to set the font color to
white.

--
Duane Hookom
MS Access MVP

"jk" <(E-Mail Removed)> wrote in message
news:AE1EB157-B5A5-4266-B184-(E-Mail Removed)...
> Hello Duane,
>
> The zeros that appear also appear on reports as well as query and they do
> not affect the totals.I am looking to remove them so they dont show up so
if
> there is something that whites them out or any other method, please advise
on
> the most practical way.Much thanks for your support.
>
> "Duane Hookom" wrote:
>
> > Can you provide any hint as to what you mean by "remove the zeros"?
> > White-out?
> >
> > Do you want to filter out records? Do you want to change 0 to null?
> >
> > --
> > Duane Hookom
> > MS Access MVP
> >
> >
> > "jk" <(E-Mail Removed)> wrote in message
> > news:985803FD-BE39-44E8-A0F9-(E-Mail Removed)...
> > > Hello,
> > >
> > > My query runs great but i have zero values appear in some coulmns.How
do
> > you
> > > remove the zeros?
> > > Thanks
> >
> >
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Zero values not legend, Value grater then zero show data and legend	Pamela	Microsoft Excel Misc	0	27th Jan 2009 11:29 PM
dividing zero by zero in a query, getting #error	Tina S	Microsoft Access	7	10th Jul 2008 03:17 AM
if less then zero put zero if greater then zero state number	=?Utf-8?B?UGFtZWxhIEplYW4=?=	Microsoft Excel Worksheet Functions	2	17th Oct 2006 08:36 PM
zero values in charts-don't want to show as zero, but as blank	=?Utf-8?B?TUw=?=	Microsoft Excel Misc	3	2nd Aug 2005 10:51 PM
Query to Show Zero even when the Count is Zero	Herbert Chan	Microsoft Access Queries	2	17th Jan 2004 03:56 PM