Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Easy Query Question I think 1

Status
Not open for further replies.
Bkster

Bkster

Technical User
Jan 25, 2002
94
US
I have a comment field that is optional. So I have records that are blank. The field type is memo. I want the query to only display the fields that have data in them. I have tried <>&quot;null&quot; but it is not working. Any ideas?

Thanks
Brian Russell
 
Sort by date Sort by votes
I had tried that and it did not work. This information is being inserted from a web form. I am not sure what the problem is. Thanks
 
Upvote 0 Downvote
sorry to question this but you have used

IS NOT NULL rather than <>NULL

failing that, maybe you are inserting a space rather than a null - try <>&quot; &quot;
 
Upvote 0 Downvote
The <>&quot;&quot; got it. Thanks alot.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Query expression negative to a 0
Replies
6
Views
379
dhookom
dhookom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
875
strongm
strongm
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
266
OzFoxy
OzFoxy
breezett93
  • Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
5
Views
122
Chriss Miller
C
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
4K
combo
combo

Part and Inventory Search

Sponsor

Back
Top