Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006

    Unanswered: Sql Query Issue - MS Acess

    Currently, I am using MS Acess to generate my query for the form. Basically, I have created an input box to prompt user for an input. What I want to achieve is to allow the user to key in first alphabet and that alphabet will be listed in the table. Ex: if the user enter "ha*". All the field starting with "ha*" will be shown. All the user have to do is to key in the letter and that letter will be displayed using an sql query statement with Like clause. It will take whatever input from the user and list in the tables and sort according to the input.

  2. #2
    Join Date
    Mar 2004
    try something like this

    SELECT tabel1.field1
    FROM [table1]
    WHERE (((table1.field1) Like [input]));

    this will ask for [input] i.e a*

Posting Permissions

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