Display NOT NULL COLUMN ONLY in query

[ezybusy]

Hi everyone,
i have the following query based on only one table.



SELECT Tbl_Fertilizers.FertilizerHSCode, Tbl_Fertilizers.Class, Tbl_Fertilizers.FertilizerName, Tbl_Fertilizers.FertilizerForm, Tbl_Fertilizers.N, Tbl_Fertilizers.P2O5, Tbl_Fertilizers.K2O, Tbl_Fertilizers.S, Tbl_Fertilizers.MgO, Tbl_Fertilizers.CaO
FROM Tbl_Fertilizers
WHERE (((Tbl_Fertilizers.FertilizerHSCode) Like [CODE] & '*'));

Not i would like "not to display columns that do not have values" while keeping the parameter [CODE] in place.
Any idea about how to go about it?

[ranman256]

This idea makes no sense. Just query all columns, ignore the blanks.

[ItsMe]

I do not understand either. If you do not want the nulls retrieved, replace your WHERE clause with Is Not Null in the criteria field for FertilizerHSCode