Missing Iformation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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????
 
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
 
Back
Top