text expressions that are parameterized by a form

[beeth]

Goodmorning everyone,
I have a very simple problem (for you) with the syntax of a query.
I have a table with a ZIP CODE text field of 5 characters (the ZIPs are international ie a few times of 5 other than 4 characters). The extraction criteria IN ONE QUERY are through a 2-character TEXTZIP field of a FormPrint.
I would like to extract all the ZIPs that start for those 2 characters, ie if inserting it into the form is 11 "LIKE" 11 ??? which results in all ZIPs starting with 11.

In the criteria line I tried to insert the strings
[code] Like "[Forms]! [FormPrint]! [ZIPCODE] ???"
Like "[Forms]! [FormPrint]! [ZIPCODE] & ???"
Like '[Forms]! [FormPrint]! [ZIPCODE] & ???' [/ code]

but none of the 3 examples work (either with quotes or double quotes)

Then there will be a problem of working on 4 and 5 characters, but I think I can get it with an OR and enter 2 or 3 interrogators.

Something like this

 Like "[Forms]! [FormPrint]! [ZIPCODE] ??" OR Like "[Forms]! [FormPrint]! [ZIPCODE] ???"

Can anybody give me some indication?
Thanks in advance

[June7]

What is the field name in table - [Zip Code]? What is name of textbox on form - ZIPCODE?

SELECT * FROM sometable WHERE [Zip Code] Like [Forms]![FormPrint]![ZIPCODE] & "*"

[beeth]

thank you june7