Displaying values that are NOT NULL, only

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Back
Top