Hiding cells with no value in a report

Joined
Jun 23, 2011
Messages
1
Reaction score
0
Totally new to Access, as in 2 months. When I run a report from a query in Access 2007 it brings back empty cells which leave empty spaces in a report. I would like to hide the empty spaces and have everything move up/left or right (basically adjust for the hidden cell). If I enter ‘isnull’ in the criteria it excludes the whole line. Everything in the line, I just want the empty cell excluded/hidden


The query reports on: Name, University, and Graduation date


Example:

Name: John Doe
University: Kansas State University
Graduation date: 8/1/2006
Name: Jane Doe
University: Kansas University
Graduation date: 8/1/2007


If there is not data in a cell it looks like this:

Name: Jane Doe

Graduation date: 8/1/2007
Name: Jane Doe
University: Kansas University
Graduation date: 8/1/2007


I would like for it to exclude or hid the empty cell, looking like this:

Name: John Doe
Graduation date: 8/1/2006
Name: Jane Doe
University: Kansas University
Graduation date: 8/1/2007
 
Last edited:
Back
Top