Use Parameter in select statement (Sql in Microsoft Access)
Results 1 to 3 of 3

Thread: Use Parameter in select statement (Sql in Microsoft Access)

  1. #1
    Join Date
    Jul 2012
    Posts
    2

    Use Parameter in select statement (Sql in Microsoft Access)

    Hi everybody,

    I'm newbie in Microsoft access and I wanna know how we can use a Parameter in Select statement (SQL view)?
    ( actually I want to get a number from user and use it for selecting some random records)
    tanks in advance

  2. #2
    Join Date
    Jul 2012
    Posts
    2

    Re: Use Parameter in select statement (Sql in Microsoft Access)

    SELECT * FROM tablename WHERE fieldname = [enter number];

    Nimol
    Programmer
    Corbin Creative Databases, LLC
    http://www.corbincreative.com

  3. #3
    Join Date
    Dec 2012
    Posts
    1
    A more detailed SQL in MS Access parameter discussion:
    http://blogannath.blogspot.com/2010/...parameter.html

Posting Permissions

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