Search results

Hi David / Olxx thanks for the replies , i will try the additional query route although i tried something similar without luck but i think i may have left something out. The report is only for internal use but every cent has to be accounted for , the zeros are more so an anoyance than a major...

Hi Olxx, Thanks for the reply but the problem seems to be with the report summing rather than the query as there is already a criteria in the query excluding zeros. the zeros only come about as there is a Sum in the report. i.e i may have 2 records grouped one with +1000 value and the other...

Hi All, Hope someone can help with this query. I have a report that i need to alter to exclude 0 values however its not just a case of changing the format property(i think) as i want the whole line excluded not just the 0 value surpressed. the report works off a query and the control source...