G
Guest
I have a query that creates a table with 7 total columns. What I would like
to do is create that table so that if 4 specific fields of a record are null,
they will not appear in the table.
For example:
ColumnA ColumnB ColumnC ColumnD ColumnE ColumnF ColumnG
I need something that will not show the record if columns C,D,E, and F, are
null. There are cases where one column lets say D will have data but not C,E,
or F. I want these records included. ONLY IF ALL 4 COLUMNS ARE NULL do I want
to exclude the record.
Hope that explains it.
Thanks in advance for your replies.
Bill
to do is create that table so that if 4 specific fields of a record are null,
they will not appear in the table.
For example:
ColumnA ColumnB ColumnC ColumnD ColumnE ColumnF ColumnG
I need something that will not show the record if columns C,D,E, and F, are
null. There are cases where one column lets say D will have data but not C,E,
or F. I want these records included. ONLY IF ALL 4 COLUMNS ARE NULL do I want
to exclude the record.
Hope that explains it.
Thanks in advance for your replies.
Bill