Parameter Query with Wildcards

[Guest]

I have a number such as 288E3334 & 288E3334-001. I ask the user to enter
base number such as 288E334 but I want the query to return both of the above
numbers if they both are there. I have tried [Enter Item]&"*" but nothing
returns. However, if I enter "Like 288E3334*" then the query returns all
instances.

Also, Can you have user enter multiple items with a parameter query that
will return results? Have user be prompted to enter a list of numbers which
will return that list along with other related information. Or can the query
pull a list of numbers out of a table to match values in another table. For
example:
Table1
Field1 Field2
288E1111 Bracket
288E1111-001 Bracket
277K9999-003 Relay
277M0001-002 Relay
277M0001 Relay

Table2
Field1
288E1111
288E1111-001
277K9999-003

So pull all numbers in Table 2 that matches Table1 and return both Field1
and Field2 if there is a match or multiple matches. There are about 75
numbers in my current table that I need to find in my existing database.
Make sense? Not sure what criteria to enter into the query...

 

[Guest]

You are very close:

Like [Enter Item] & "*"