Parameter Query

[Guest]

I am trying to create a query that asks the user to enter the inital of the
customers last name. So "S" would show all people with last names beginning
with S.

Thanks to all!!!
Bruce DiPaola

 

[Guest]

Hey Bruce, a little more information would be helpful to provide a more
complete answer but this is easy to do...

I'm assuming your field name is LastName:

In design view of the query, in the Criteria field for LastName enter the
following:

Like "*" & [Enter First Initial of Last Name] & "*"

The Like operator allows you to query for information that contains the data
the user enters. The information contained in the [] will prompt the user to
with the message you want. Also, the user can enter more than the first
letter for more accurate results.

 

[Guest]

That does it!!! much gratitude....
--
Bruce DiPaola

Hey Bruce, a little more information would be helpful to provide a more
complete answer but this is easy to do...

I'm assuming your field name is LastName:

In design view of the query, in the Criteria field for LastName enter the
following:

Like "*" & [Enter First Initial of Last Name] & "*"

The Like operator allows you to query for information that contains the data
the user enters. The information contained in the [] will prompt the user to
with the message you want. Also, the user can enter more than the first
letter for more accurate results.

I am trying to create a query that asks the user to enter the inital of the
customers last name. So "S" would show all people with last names beginning
with S.

Thanks to all!!!
Bruce DiPaola