Anything beginning with "aim"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hiya there. I'm building a query, where by it includes a parameter e.g.
[Please enter Application Name:]

If the user searches for a word 'aim' its okay as that's listed on the
actual records/table as 'aim' but if the user wants something from 'adobe' in
my database they need to type in the whole word, For example
'adobe_AcrobatsElementsFR'.

I tried building another expression, but I just can't seem to get it
right... Any suggestions?


Many thanks,
 
Hey Jeff,

It doesn't actually seem to be working... Tried that before, no good :(

I'm using MS Access (query view) to build this query.

--
Kj.


Jeff Boyce said:
In the selection criterion "cell", use something like the following:

Like * & [Enter a portion of the Application Name] & *

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Kj said:
Hiya there. I'm building a query, where by it includes a parameter e.g.
[Please enter Application Name:]

If the user searches for a word 'aim' its okay as that's listed on the
actual records/table as 'aim' but if the user wants something from 'adobe' in
my database they need to type in the whole word, For example
'adobe_AcrobatsElementsFR'.

I tried building another expression, but I just can't seem to get it
right... Any suggestions?


Many thanks,
Click to expand...
Click to expand...
 
You may need to use "%" as the wildcard instead of "*". Also I note that
Jeff forgot to include the text delimiters.

Try
Like "*" & [Enter a portion of the Application Name] & "*"

IF that fails then try
Like "%" & [Enter a portion of the Application Name] & "%"

IF you want to limit the data to finding applications that start with the
entry then
Try
Like [Enter a portion of the Application Name] & "*"

IF that fails then try
Like [Enter a portion of the Application Name] & "%"


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Kj said:
Hey Jeff,

It doesn't actually seem to be working... Tried that before, no good :(

I'm using MS Access (query view) to build this query.

--
Kj.


Jeff Boyce said:
In the selection criterion "cell", use something like the following:

Like * & [Enter a portion of the Application Name] & *

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Kj said:
Hiya there. I'm building a query, where by it includes a parameter e.g.
[Please enter Application Name:]

If the user searches for a word 'aim' its okay as that's listed on the
actual records/table as 'aim' but if the user wants something from
'adobe' in
my database they need to type in the whole word, For example
'adobe_AcrobatsElementsFR'.

I tried building another expression, but I just can't seem to get it
right... Any suggestions?


Many thanks,
Click to expand...
Click to expand...
Click to expand...
 
Yeah, I figured, used "*" ... "*" and it worked.



thanks :)) ..!!


--
Kj.


John Spencer said:
You may need to use "%" as the wildcard instead of "*". Also I note that
Jeff forgot to include the text delimiters.

Try
Like "*" & [Enter a portion of the Application Name] & "*"

IF that fails then try
Like "%" & [Enter a portion of the Application Name] & "%"

IF you want to limit the data to finding applications that start with the
entry then
Try
Like [Enter a portion of the Application Name] & "*"

IF that fails then try
Like [Enter a portion of the Application Name] & "%"


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Kj said:
Hey Jeff,

It doesn't actually seem to be working... Tried that before, no good :(

I'm using MS Access (query view) to build this query.

--
Kj.


Jeff Boyce said:
In the selection criterion "cell", use something like the following:

Like * & [Enter a portion of the Application Name] & *

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Hiya there. I'm building a query, where by it includes a parameter e.g.
[Please enter Application Name:]

If the user searches for a word 'aim' its okay as that's listed on the
actual records/table as 'aim' but if the user wants something from
'adobe'
in
my database they need to type in the whole word, For example
'adobe_AcrobatsElementsFR'.

I tried building another expression, but I just can't seem to get it
right... Any suggestions?


Many thanks,
Click to expand...
Click to expand...
Click to expand...
 
Kj

Please post back the SQL statement that is your current query.

John

Nah, I didn't omit them, I just didn't bother putting them in. If you type
what I gave into the Selection Criterion "cell" in query design view, Access
adds the delimiters.

So, I was being ... efficient <g>.

Regards

Jeff Boyce
Microsoft Office/Access MVP

John Spencer said:
You may need to use "%" as the wildcard instead of "*". Also I note that
Jeff forgot to include the text delimiters.

Try
Like "*" & [Enter a portion of the Application Name] & "*"

IF that fails then try
Like "%" & [Enter a portion of the Application Name] & "%"

IF you want to limit the data to finding applications that start with the
entry then
Try
Like [Enter a portion of the Application Name] & "*"

IF that fails then try
Like [Enter a portion of the Application Name] & "%"


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

Kj said:
Hey Jeff,

It doesn't actually seem to be working... Tried that before, no good :(

I'm using MS Access (query view) to build this query.

--
Kj.


Jeff Boyce said:
In the selection criterion "cell", use something like the following:

Like * & [Enter a portion of the Application Name] & *

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Hiya there. I'm building a query, where by it includes a parameter e.g.
[Please enter Application Name:]

If the user searches for a word 'aim' its okay as that's listed on the
actual records/table as 'aim' but if the user wants something from
'adobe'
in
my database they need to type in the whole word, For example
'adobe_AcrobatsElementsFR'.

I tried building another expression, but I just can't seem to get it
right... Any suggestions?


Many thanks,
Click to expand...
Click to expand...
Click to expand...
 
Back
Top