Results 1 to 2 of 2

Thread: SQL Statement

  1. #1
    Join Date
    May 2004
    Posts
    18

    Unanswered: SQL Statement

    I know this is a very basic question, But how do i write an SQL Statement in MS Access.

    I need to have an SQL statement from a form.

    The SQL will go to a specific record on a table

    For instant
    Go to Table1 at LastName = "Bob" or something like that

    Thanks in advance whoever is helping me

  2. #2
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    Fastest way to create a SQL statement is creating a query. But it is still not the answer you need.
    Create a Form for your table with one of the form wizards then add a Combobox or Listbox to your form. You will have an option to create a combobox which finds records in your form. But make sure wizard option is on.
    ghozy.

Posting Permissions

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