Don't print records with null values

L

Lyn new at access

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.
 
D

Duane Hookom

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
 
L

Lyn new at access

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

Lyn new at access

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.
 
D

Duane Hookom

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"?
 
L

Lyn new at access

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.
 
D

Duane Hookom

If your report's record source has 0 in a particular column and your criteria
under this column is
0
Click to expand...
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.
 
Top