ExcelBanter - Show Non Blanks using MS Query

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Show Non Blanks using MS Query (https://www.excelbanter.com/excel-discussion-misc-queries/122657-show-non-blanks-using-ms-query.html)

hjm

Show Non Blanks using MS Query

How do I show non-blanks only, using MS Query?

Ron Coderre

Show Non Blanks using MS Query

If the record fields truly are null (not spaces or "")Try using "IS NOT NULL"
in the criteria:

Sample SQL:
SELECT rngMyData.Name, rngMyData.Value
FROM `C:\ExcelQueries\Lists`.rngMyData rngMyData
WHERE (rngMyData.Value Is Not Null)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

"hjm" wrote:

How do I show non-blanks only, using MS Query?

hjm

Show Non Blanks using MS Query

Thats great, thank you

"Ron Coderre" wrote:

If the record fields truly are null (not spaces or "")Try using "IS NOT NULL"
in the criteria:

Sample SQL:
SELECT rngMyData.Name, rngMyData.Value
FROM `C:\ExcelQueries\Lists`.rngMyData rngMyData
WHERE (rngMyData.Value Is Not Null)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

"hjm" wrote:

How do I show non-blanks only, using MS Query?

All times are GMT +1. The time now is 01:37 AM.