Combo Box to Not Show Blanks - Is Not Null?

[Ben M]

Hi,

I have a combo box on a form that refers to a table for the full list which is displayed in descending order. Within the table there are some blanks. I would still like the list to display in descending order but not show the blanks. It looks like I need to incorporate Is Not Null somewhere in the below but when I try and add it I keep getting errors? Any suggestions would be greatly appreciated.

SELECT TblOracleVendorData.[BANK ACCOUNT NUMBER] FROM TblOracleVendorData ORDER BY TblOracleVendorData.[BANK ACCOUNT NUMBER] DESC;

Thanks

 

[mole999]

Not sure, but
SELECT
TblOracleVendorData.[BANK ACCOUNT NUMBER]
FROM
TblOracleVendorData
WHERE
TblOracleVendorData.[BANK ACCOUNT NUMBER] IS NOT NULL
ORDER BY TblOracleVendorData.[BANK ACCOUNT NUMBER] DESC;