Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2010
    Albany, NY
    Thanked 0 Times in 0 Posts
    I have a small MySQL database that has MS Access 2007 as its front end. One of the tables in that database contains address data across several fields. One of the fields is a zip code field called Zip. The field is 5 characters and is a text field.

    I am trying to write a query that will prompt the user to enter the first FOUR digits of the zip code, which will then return all the records which match those four digits. For example, 1234 would return 12345, 12346, and 12347 and so on.

    I know that Access supports [bracketed] input in queries, but I am not sure how it works for a partial match. I suspect something along the lines of:

    SELECT * FROM vendors WHERE Zip LIKE [Enter 4 digits]%

    But I know that query does not work, Access does not like the % symbol.

    Can anyone tell me what would be the proper syntax for such a query that would allow the user to specify the first four digits and then return all the records matching those four digits?

    Thank you!

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 58 Times in 58 Posts
    If you are working with ODBC linked tables, you need to use the Access syntax rather than mySQL or ANSI Standard. The statement would look something like:

    SELECT * FROM vendors WHERE Zip Like [Enter 4 digits] & "*"

    The ampersand is used to concatenate the * character which is the wildcard character for Access to the SQL string.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts