Displaying values that are NOT NULL, only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to only display values in a report that are NOT NULL for each
record?
 
Isn't this what happens anyway? Null values aren't anything so I'm not sure
what you don't want to display.
 
What I would like, exactly, is the following:

If I take 50 people (records) and check off a list of locations travelled
from a master list (using the YES/NO option), I would like to be able to pull
up a sheet for each person ONLY listing the places they have travelled.

I do NOT want to see all possible travel options with blanks next to them.

Does this make more sense?
 
This would only make sense if your table structure was un-normalized. It
seems that you might be storing locations as field names rather than values
in records.

We don't know anything about your table structure so we can't provide a long
term solution.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

grouping based on checkboxes 1
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
if it is null how not to get the #error 1
Null Values in reports 4
Adding Null value in Access Reports 1
Reporting null values or blank sheets 3
Need expression Help on displaying value 2
How do I hide fields with null values on a report? 1

Back
Top