Parameter Query

[Julie]

Hi!

I've created a parameter query that prompts for First
Name, then Last name. Then we get a list of people that
match the criteria. Works great. Except when we
have "Bill Scott III". Then I have to type "III" to catch
all of his entries. What can I enter at the prompt
(tried "*", didn't work) or how can I modify the query to
say "include Scott, plus anything else, like Jr., Sr.,
III, etc.)

All of the suffix data was included with the last name,
and this cannot be put in a separate field.

We are stumped! Thanks!

 

[John Spencer (MVP)]

Depends on what you want to happen? If you want an entry of "Scott" to return
only "Scott Jr", but not "Scottie" then you need to include criteria like:

Criteria: LIKE [Enter Last Name] OR LIKE [Enter Last Name] & " *"

On the other hand, if you want Scott and Scottie and Scottie III, then

Criteria: LIKE [Enter Last Name] & "*"

 

[Julie]

YOU ARE AWESOME!!!!!!!!!!!!!!!!!!

-----Original Message-----
Depends on what you want to happen? If you want an entry of "Scott" to return
only "Scott Jr", but not "Scottie" then you need to include criteria like:

Criteria: LIKE [Enter Last Name] OR LIKE [Enter Last Name] & " *"

On the other hand, if you want Scott and Scottie and Scottie III, then

Criteria: LIKE [Enter Last Name] & "*"

Hi!

I've created a parameter query that prompts for First
Name, then Last name. Then we get a list of people that
match the criteria. Works great. Except when we
have "Bill Scott III". Then I have to type "III" to catch
all of his entries. What can I enter at the prompt
(tried "*", didn't work) or how can I modify the query to
say "include Scott, plus anything else, like Jr., Sr.,
III, etc.)

All of the suffix data was included with the last name,
and this cannot be put in a separate field.

We are stumped! Thanks!

.