UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Query on memo field    
 
   
george830
post Oct 20 2004, 06:07 PM
Post #1

UtterAccess Ruler
Posts: 1,009
From: Overland Park, Kansas
I have a field which is a memo field whereby the user can enter problems they are having. I want to do a query on all of the records where the memo field has something in it.

Is this possible and what does the query need to search for this data. I have ujsed > null but that did not work.

tia
Go to the top of the page
 
+
erwardell
post Oct 20 2004, 06:26 PM
Post #2

VIP Emeritus
Posts: 1,340
If you do not want nulls then use the Is Not Null in the criteria. If you are looking for a specific word then use the like '*Word*' in the criteria to find all records with that word in it.
Go to the top of the page
 
+
george830
post Oct 21 2004, 08:29 AM
Post #3

UtterAccess Ruler
Posts: 1,009
From: Overland Park, Kansas
Works great thanks.
Go to the top of the page
 
+
erwardell
post Oct 21 2004, 11:11 AM
Post #4

VIP Emeritus
Posts: 1,340
Your welcome (IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 05:54 AM