Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 02-24-2011, 10:23 AM
tpcervelo tpcervelo is offline MS Query IsNull issue Windows XP MS Query IsNull issue Office 2003
MS Query IsNull issue
Join Date: Sep 2010
Posts: 5
tpcervelo is on a distinguished road
Default MS Query IsNull issue

I have an Excel MS Query that checks a text field (Binloc) for data by the Is Not Null operator using Synergy's ODBC client. This query works and only returns records with Bin locations. In preparation to move to SQL 2008 database the same query returns all records. SQL obvioulsly considers the field space or something other than null. I cannot find an operator that allows me to test both null and space.
Any help is much appreciated.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Query IsNull issue Need an Automated sql query for the Excel file Karthick Excel 3 12-20-2010 04:52 AM
Word (Mail Merge) Refreshes Query Too Often! amarsha4 Mail Merge 1 11-10-2010 09:12 AM
Text Box Query Meljord Word 3 12-15-2009 12:25 PM
How to write in Word from Select query lakhan.p Word 0 03-27-2009 07:25 AM
Mail Merge Query kangabanga Mail Merge 0 09-25-2008 04:07 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 11:59 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft