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?