Criteria question

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

Guest

I have a query with a field called “Contractor Nameâ€. I want to be able to
search for records that contain part of a name defined by an input on opening
the query. In criteria, if I use [Enter Contractor Name], it will only find
records matching that exact name. For example, if I enter Fred in the
question window it will not include “Fred Smithâ€. What can put in criteria
that will find the example “Fred Smith†in the input window if for example I
put in smit.

Any help would be much apriciated J
 
Simon

Use a wildcard that matches any number of (other) characters. You could
try:

Like * & [Enter last name]

or even

Like * & [Enter name] & *

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Cheers Jeff!

It worked just like it said on the can.

Jeff Boyce said:
Simon

Use a wildcard that matches any number of (other) characters. You could
try:

Like * & [Enter last name]

or even

Like * & [Enter name] & *

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


Simon said:
I have a query with a field called “Contractor Nameâ€. I want to be able to
search for records that contain part of a name defined by an input on opening
the query. In criteria, if I use [Enter Contractor Name], it will only find
records matching that exact name. For example, if I enter Fred in the
question window it will not include “Fred Smithâ€. What can put in criteria
that will find the example “Fred Smith†in the input window if for example I
put in smit.

Any help would be much apriciated J
Click to expand...
Click to expand...
 
Back
Top