Criteria [?] in Query - Searching

  • Thread starter Thread starter yokim
  • Start date Start date
Y

yokim

I'm new in access and I found that access is very
interesting. Here is my problem. I make a query with a
field X that will pop up with question or input from user
( I used criteria [?] in field X). If I want to find data
ABCDEFGH, I input ABCDEFGH. This is doing fine, but my
problem is if I want to input a word that was not
completed, this query goes nothing. I want that if I want
to search data ABCDEFGH in field A, I just input ABC*,
and it will find it.
Could somebody help me please..??

Regards
'yokim
 
I'm new in access and I found that access is very
interesting. Here is my problem. I make a query with a
field X that will pop up with question or input from user
( I used criteria [?] in field X). If I want to find data
ABCDEFGH, I input ABCDEFGH. This is doing fine, but my
problem is if I want to input a word that was not
completed, this query goes nothing. I want that if I want
to search data ABCDEFGH in field A, I just input ABC*,
and it will find it.
Could somebody help me please..??

Regards
'yokim
Click to expand...

As criteria use ....
To find the text anywhere in the field:
Like "*" & [Enter text] & "*"

To find the text only at the beginning of the field:
Like [enter text] & "*"

To find the text only at the end of the field:
Like "*" & [enter text]
 
Thank u very much. It's work exactly like I need it.
Mucha gracias. Sie-sie.
-----Original Message-----
I'm new in access and I found that access is very
interesting. Here is my problem. I make a query with a
field X that will pop up with question or input from user
( I used criteria [?] in field X). If I want to find data
ABCDEFGH, I input ABCDEFGH. This is doing fine, but my
problem is if I want to input a word that was not
completed, this query goes nothing. I want that if I want
to search data ABCDEFGH in field A, I just input ABC*,
and it will find it.
Could somebody help me please..??

Regards
'yokim
Click to expand...

As criteria use ....
To find the text anywhere in the field:
Like "*" & [Enter text] & "*"

To find the text only at the beginning of the field:
Like [enter text] & "*"

To find the text only at the end of the field:
Like "*" & [enter text]
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top