Help with a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to make a query ask for an input and I can't make it happen. I
was able to in the older versions of access by putting a "LIKE" statement in
the criteria on the actual query. Access 2003 doesn't like that and it won't
let me do this. Does anyone have any ideas???

Thanks
 
It works OK for me in access 2003

I can put in [Enter Code] in the criteria line and it prompts me to enter a
code, which I do and my query returns the relevant records.
I can also use Like [Enter Code] & "*"
to find any letter at the beginning of my code or
Like "*" & [Enter Code] & "*"
to find a letter anywhere in my code.
 
Alan,

Would you care to post what your code looks like? The SQL keyword LIKE has
nothing to do with whether or not you are prompted for input.
 
Back
Top