Don't print records with null values

[Guest]

I have a report that lists all new hires by department and sub department.
If there are no new hires in a department/subdepartment, I do not want to
print that record. Only the department/subdepartment that has a value that
is not null. How would I do this? For example,

Accounting Admin 0
Accounting Finance 3
Accounting Collections 2

I do not want to print Accounting Admin on the report, just the other 2
records.

I am new to access so please help.

 

[Guest]

You generally apply a filter to the report's record source query. The easiest
method is to set the criteria under the appropriate column to

 

[Guest]

Duane, what about the 'can shrink' property on the report. Should I set that
to yes?

 

[Guest]

Duane,

I tried this, I set the criteria in the query to >0 in the column where the
counts are, but it still showed me every record.

 

[Guest]

If you are thinking the Can Shrink property might help, you better tell us
something about your report's record source. Do you have field/column names
like "Finance" and "Admin"?

 

[Guest]

Duane,

I have a query that sums the Dept and Sub Dept. I have another query that
sums the counts by Dept and Sub Dept. I then join the two queries into a
final query. This final query shows all the Dept with their sub depts
whether there are any counts or not. This final query is the one that I use
in the report. In the report it is showing everything in the final query,
whether there are counts or not. I only want it to show rows where at last
there is a count greater than null.

 

[Guest]

If your report's record source has 0 in a particular column and your criteria
under this column is

0

Then you should not be seeing records where the column value is zero.

If you can't figure this out, we might need to see your SQL view of your
queries.