Help with a Query

A

Alan

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
 
D

Dennis

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.
 
C

Chaim

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.
 
Top