Zero values in query

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

Guest

Hello,

My query runs great but i have zero values appear in some coulmns.How do you
remove the zeros?
Thanks
 
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?
 
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.
 
Back
Top