Search Qry

[ICTkirsten]

Hello,

Im trying to make a query on one of my forms..
and i had this code from class but i think i may have copied it wrong..
"e "*"" & [Enter Surname] & "*"

i know there was the word Like in the code somewhere but i cant remember

Please may i be advised

thanks

 

[CJ_London]

it will be something like

 SELECT *
 FROM myTable
 WHERE myfield like "*" & [Enter Surname] & "*"