Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
"Like" Queries
11 views
Skip to first unread message
Art
Sep 13, 2007, 9:48:19 AM9/13/07
to
Is there a simple way to do a "like" query in IP 2003?
The user wants to just type in the first 3 characters of a field and return
all those that start with "ABC"
S.Y.M. Wong-A-Ton
Sep 14, 2007, 3:42:01 AM9/14/07
to
Hey Art! Long time no see! There is no easy way to do this; you will have to
write code. I did something similar with numbers in this article
http://enterprise-solutions.swits.net/infopath2003/query-access-database-list-numbers.htm ; you could alter it to use a "like".
---
S.Y.M. Wong-A-Ton
write code. I did something similar with numbers in this article
http://enterprise-solutions.swits.net/infopath2003/query-access-database-list-numbers.htm ; you could alter it to use a "like".
---
S.Y.M. Wong-A-Ton
Art
Sep 17, 2007, 9:16:17 AM9/17/07
to
Yes it has been a long time. Have to brush off my IP skills to do some more
forms
forms
Actually, rather than going the code route, I just created a SQL view of my
table and added a new column of just the left 3 so I can search that way and
can bypass the %like% issue.
"S.Y.M. Wong-A-Ton" <SYMWo...@discussions.microsoft.com> wrote in message
news:C7DB732A-D831-47D5...@microsoft.com...
S.Y.M. Wong-A-Ton
Sep 17, 2007, 8:50:04 PM9/17/07
to
That one did not occur to me; thanks for the tip.
0 new messages