Missing Iformation

R

Rob

I have a query that is picking up information from an imported Excel
spreadsheet.

Under my part code heading i have around 100 codes with no number showing
although they are present in the spreadsheet.

I am looking to set up a query to pick up only descriptions that do not have
a value entered under the part code.

What is the best way to do this????
 
A

Amy Blankenship

Rob said:
I have a query that is picking up information from an imported Excel
spreadsheet.

Under my part code heading i have around 100 codes with no number showing
although they are present in the spreadsheet.

I am looking to set up a query to pick up only descriptions that do not
have
a value entered under the part code.

What is the best way to do this????
Click to expand...

Depending on whether the information is truly missing (null) or merely empty
(""), you could try

SELECT Description from YourTable WHERE PartCode IS Null

or

SELECT Description from YourTable WHERE PartCode = ''

HTH;

Amy
 
Top