Report prints data I don't want to see

[Kautzen]

I have a report that comes from basically one table (Program name comes from
a second table), but the data prints with lines with zero's in it. I know
why it is doing so, but need to know how to not print the non informative
lines.
The report is for a general ledger entry and is a summary of mileage paid to
staff(I do not print the detail in this report). The data is for client
miles and admin miles and they are on the same detail line. I sort the data
by admin and client and that works well. I have the Admin printing on the
right side of the report and the client on the left side. The Admin prints
first and does well, but since the client is the second sort, it prints the
detail line, then a line with zeros below each detail line on the right side
where the admin information prints. I know this is due to the fact the
detail line in the table looks as show below, so how can I get the non
informative lines to not print.

employee# Date Client Miles Class Client Admin Miles Class Admin Check
662 12/31/2008 66 34 0 0
686 12/31/2008 0 0 214 44
660 12/31/2008 0 0 44 44
The Report Prints like this:
Program # Client Miles Costs Program # Admin Miles Costs

62 143 72.22
72 218 110.09
74 330 166.65
10 311 157.06
0 0 0
11 980 494.9
0 0 0
12 360 181.8
0 0 0

I hope this is not too nuch detail, but last time I had a question, I was
told to give some details

 

[Larry Linson]

Is there some compelling reason why you are not basing your Report on a
Query with criteria to eliminate the undesired records? Access Reports and
Forms can be based on Queries, and do not have to directly refer to the
Tables.

Larry Linson
Microsoft Office Access MV{

 

[Kautzen]

It is based on a query that give me the month data that I want from the
table, then to the report. I have not found a way to eliminate the undesired
info.

 

[Larry Linson]

I understand you do not want to see data from Records with zero or null in
certain Fields. Include a criteria for those Fields Is Not Null And <> 0.
That should eliminate the Records with the zero values. If I have
misunderstood, please clarify what defines a Record that you do not want to
see.

Larry Linson
Microsoft Office Access MVP

 

[Larry Linson]

I understand you do not want to see data from Records with zero or null in
certain Fields. Include a criteria for those Fields Is Not Null And <> 0.
That should eliminate the Records with the zero values. If I have
misunderstood, please clarify what defines a Record that you do not want to
see.

Larry Linson
Microsoft Office Access MVP

 

[Kautzen]

Hi Larry,
I have tried the <>0 or is null and when I do, the other records do not print.