| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show Non Blanks using MS Query
How do I show non-blanks only, using MS Query?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems importing from an Access query | Excel Discussion (Misc queries) | |||
| MS Query - unable to edit query | Excel Discussion (Misc queries) | |||
| Incorrect syntax near '#' problem when returning to MS Query fromExcel | Excel Discussion (Misc queries) | |||
| Formula Help | Excel Worksheet Functions | |||
| MS Query not installed for New Database Query | Excel Discussion (Misc queries) | |||
Linear Mode
