(Msg. 1) Posted: Mon Oct 06, 2008 12:30 pm
Post subject: Query results Archived from groups: microsoft>public>access (more info?)
I'm trying to get the criteria in my query to produce a form that shows a
list by customer. Say my customer name is ralph but it might have different
offices so in our customer database we might have ralph-windsor or
ralph-london. I want them to be able to type in "ralp" and get any customer
with "ralp" in it. I've tried a few "like" option with different wildcards
but I can't get quite the right results. I figure this one should be pretty
easy.
Thanks.
--
One day I may know what I''''''''m doing.
(Msg. 2) Posted: Mon Oct 06, 2008 1:18 pm
Post subject: RE: Query results [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Like [Enter start of search] & "*"
or
Like "*" & [Enter start of search] & "*"
--
KARL DEWEY
Build a little - Test a little
"Sean" wrote:
> I'm trying to get the criteria in my query to produce a form that shows a
> list by customer. Say my customer name is ralph but it might have different
> offices so in our customer database we might have ralph-windsor or
> ralph-london. I want them to be able to type in "ralp" and get any customer
> with "ralp" in it. I've tried a few "like" option with different wildcards
> but I can't get quite the right results. I figure this one should be pretty
> easy.
>
> Thanks.
> --
> One day I may know what I''''''''m doing.
(Msg. 3) Posted: Mon Oct 06, 2008 1:31 pm
Post subject: RE: Query results [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
just type *ralp*
or use this in your query:
WHERE (((tableName.FieldName) Like "*ralp*"));
Thanks
LD
--
Lorenzo DÃaz
Cad Technician
"Sean" wrote:
> I'm trying to get the criteria in my query to produce a form that shows a
> list by customer. Say my customer name is ralph but it might have different
> offices so in our customer database we might have ralph-windsor or
> ralph-london. I want them to be able to type in "ralp" and get any customer
> with "ralp" in it. I've tried a few "like" option with different wildcards
> but I can't get quite the right results. I figure this one should be pretty
> easy.
>
> Thanks.
> --
> One day I may know what I''''''''m doing.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other