parameter troubles

  • Thread starter Thread starter melinda.pluma
  • Start date Start date
M

melinda.pluma

I have parameter values set to make things easier for the users...

The prompt pulls Last Name or Emp #. If the Emp# is not available, is
there a way to search by last name, including suffixes, but only
entering the last name? or even just the first letter of the last
name?
 
If your parameter is something like

Field: LastName
Criteria: [Enter Name]

Then try changing it to

Field: LastName
Criteria: LIKE [Enter Name] & "*"

It is difficult to tell you more than that since you really need to post
more detail about what you are doing. A big help would be to open the query
in SQL view and copy and paste the SQL. That way we could see what you are
currently doing and perhaps offer a more detailed solution.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
If your parameter is something like

Field: LastName
Criteria: [Enter Name]

Then try changing it to

Field: LastName
Criteria: LIKE [Enter Name] & "*"

It is difficult to tell you more than that since you really need to post
more detail about what you are doing. A big help would be to open the query
in SQL view and copy and paste the SQL. That way we could see what you are
currently doing and perhaps offer a more detailed solution.

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




I have parameter values set to make things easier for the users...
Click to expand...
The prompt pulls Last Name or Emp #. If the Emp# is not available, is
there a way to search by last name, including suffixes, but only
entering the last name? or even just the first letter of the last
name?- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

ok this worked, thank you very much!
 
Back
Top