Anything beginning with "aim"

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,
 
G

Guest

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...
 
J

John Spencer

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...
 
G

Guest

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...
 
J

Jeff Boyce

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query with Date Calculations 4
Crosstab query with parameter 13
parameter with iif statement in query criteria 8
Problem counting 5
Problems with (If no data then) with user input 2
New records not showing 4
Expression too complex ... ? 2
Report from parameter query with #Error 2

Top