creating a Select query w/ partial name input

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

Guest

Hi, how can I create a simple select query that will select records from a
table with only inputting partial name from the record ? Hope that makes
sense. Thanks.
 
In the "Criterion" row under the "name" field in your query, add something
like:

Like * & [Enter a partial name] & *

This will add wildcard search (any number of characters) both before and
after whatever search string you enter.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Oh, thank you. I actually deleted the last * because it made me type in the
partial name twice. But many thanks as it has been 4 years since I worked
with Access.

Jeff Boyce said:
In the "Criterion" row under the "name" field in your query, add something
like:

Like * & [Enter a partial name] & *

This will add wildcard search (any number of characters) both before and
after whatever search string you enter.

Regards

Jeff Boyce
Microsoft Office/Access MVP


Tall Mary said:
Hi, how can I create a simple select query that will select records from a
table with only inputting partial name from the record ? Hope that makes
sense. Thanks.
Click to expand...
Click to expand...
 
This works on a select query, but I'm trying to do the same thing on a
crosstab query and it only yields an error message. What do I need to do to
to accomplish this?

Jeff Boyce said:
In the "Criterion" row under the "name" field in your query, add something
like:

Like * & [Enter a partial name] & *

This will add wildcard search (any number of characters) both before and
after whatever search string you enter.

Regards

Jeff Boyce
Microsoft Office/Access MVP


Tall Mary said:
Hi, how can I create a simple select query that will select records from a
table with only inputting partial name from the record ? Hope that makes
sense. Thanks.
Click to expand...
Click to expand...
 
Charlie

"... an error message ..." doesn't provide much in the way of clues.

On a lark, what happens if you copy the prompt (everything between and
including the square brackets) and paste it in the Queries|Properties
window, and define the data type? I've seen some suggestions that
parameterized cross-tab queries require an explicit definition of the
parameter/data type.

Regards

Jeff Boyce
Microsoft Office/Access MVP


Charlie said:
This works on a select query, but I'm trying to do the same thing on a
crosstab query and it only yields an error message. What do I need to do
to
to accomplish this?

Jeff Boyce said:
In the "Criterion" row under the "name" field in your query, add
something
like:

Like * & [Enter a partial name] & *

This will add wildcard search (any number of characters) both before and
after whatever search string you enter.

Regards

Jeff Boyce
Microsoft Office/Access MVP


Tall Mary said:
Hi, how can I create a simple select query that will select records
from a
table with only inputting partial name from the record ? Hope that
makes
sense. Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top