help with wild cards

[chr1stoper1]

Hi guys ,Im fairly new to access and Im currently making my first database. It is a simple database using tables ,queries forms and reports ,ive not advanced to codes yet.
Currently from the switch board there are options to search for items in the database based on different parameters .Once the box on the switch board is selected it opens another box asking you to fill in what you are looking for, then it returns results. All working ok except Im trying to add another search where it will return all variants of the searched for item. For example if I am searching for a part number 5106206 I want it to return all variants ie 5106206-10 ,5106206-02, 5106206-07 .I think this is done with wild cards but ive so far had no luck in getting it to work I am not sure if it is because in the query I am using the brackets ie[ enter product].
Great forum by the way

 

[Brianwarnock]

You have not given an example of what you have coded, did you use Like?

Like [enter product] "*"

I assume that the user knows to only enter the data before the -

Brian

 

[chr1stoper1]

Hi Brian

Thanks for the reply. I have tried using like[enter detail number]"*" but it says there is something wrong with the syntax

 

[Brianwarnock]

Sorry my bad

Like [enter product] & "*"

Brian

 

[chr1stoper1]

Thanks Brian that solved my problem...much appreciated