Query expression

[Guest]

I have a simple databse that lists suppliers. I want to be able to create a
query that will search for specific company titles using the perameter
builder. However, I cannot do this because the dbase only finds full
records. eg if Im looking for a company I know is name McDonald
somethingorother ane I have two companies entered on the dbase with the name
McDonald; McDonald Ltd and ABC McDonald Co. I must put in the full name of
the company I want. However I might not know the full name. I want to be
able to search under the term McDonald to retreve these two name but, the
query simply throws no answers up at all. Is there an expression I can type
in to th crietia box that will allow me to search part of names rather than
the whole thing?

 

[Jeff L]

To get names that start with an entered value:
Like [Enter Value] & "*"

To get names that contain an entered value:
Like "*" & [Enter Value] & "*"

Hope that helps!