0 value in report

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

I have a report based on a query, which has a expense
column for all $ paid out. I have another column for
items for resale, with actual profit. Also several other
columms including date.
When something is entered which is not a expese or actual
profit, I get a $0.00 which I need to sum the column in a
report. But I also get a lot of entries which are not
needed in the report, with a 0 value. Is there some way
to exclude a record with a $0.00 value? If so how would
I do it. I have tried everything i can think of.
Kinda muddled I know, but hope it is clear enough.
Thanks for any help
Roger
 
Roger,

If your report is based on a query, can you not simply exclude the
records by putting:

<> 0

in the query criteria row for any records that apply.

Good luck,

Joe W
 
Back
Top