sorry for such a silly question. I'm trying to figure out how to write a query in access 2003 similar to the: LIKE '%'+ @parameter +'%'
in my test table...i have a record for Anthony Gwynn. In SQL, with the aforementioned LIKE query, I can type in Ant for the first name parameter and the record for Anthony Gwynn would pop up.
so far i've tried (in design view)
but so far none of these have produced any results. at least it's asking me for a parameter :P