Access query help

[NeedSomeSeriousHelp77]

I'm not sure if this can be done, but any help would be appreciated. I've created a query in access with about 10 columns.

The first column is the key that combines the tables, and then the other 9 columns ihave null or not null values.

What I need to do is pull all the records with atleast one column value. For example, the first result could have a value in column 2, and no values in any other columns. The second result could have a value in column 3, but no other values etc. I'm finding it difficult to ge these results using the "and" "or" criteria method.

Thanks again!

 

[xenou]

I came up with this:

SELECT *
FROM Table1
WHERE
Len(
 NZ([F2]) & Nz([F3]) & Nz([F4]) &  
 Nz([F5]) & Nz([F6]) & Nz([F7]) & 
 Nz([F8]) & Nz([F9]) & Nz([F10])
 )>0;

It's not exactly pretty but should do the trick. Be sure to keep a space on both sides of each & character so that Access correctly interprets the concatenation operator (though probably this is a habit I have from VBA that isn't an issue in SQL statements). We skipped Field 1 on the assumption that the ID field is required and therefore always has a value.

 

[NeedSomeSeriousHelp77]

Thank you very much! I'll give this a try. I appreciate it.