S
SUB
I think I am understanding what you want..
in your query for each column you must insert 'is not
null' in the criteria, however, as the data could land in
any one of the columns you need to make sure that all of
the 'is not null' criteria's are on different lines to
each other (sort of a stepping effect).
serial1 | serial2 | serial3 | serial4
is not null| | |
|is not null| |
| |is not null|
| | |is not null
hope this helps, cheers
SUB
in your query for each column you must insert 'is not
null' in the criteria, however, as the data could land in
any one of the columns you need to make sure that all of
the 'is not null' criteria's are on different lines to
each other (sort of a stepping effect).
serial1 | serial2 | serial3 | serial4
is not null| | |
|is not null| |
| |is not null|
| | |is not null
hope this helps, cheers
SUB