Results 1 to 2 of 2

Thread: Parameter Query

  1. #1
    Join Date
    Jan 2005
    Location
    Brooklyn
    Posts
    25

    Unanswered: Parameter Query

    Hello,

    I have a table with columns
    ID
    Period1
    Period2
    Period3
    Period4
    Period5
    Period6

    I need to create access query so that user may choose partic. period and
    that period along with id's will show up.

    Example:
    ID Period1
    1 250
    2 400
    3 25
    5 345
    8 125
    9 47


    Please help to create such query.

    Thank you

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    If you really have a table with six period fields, the first advise I have is to go back to table design and get that right first, then worry about other stuff.

    You want your user to choose the field so they can select a specific period? Can't be done with a query because your table design is totally wrong. You'll have to code it. Unless of course you choose to listen to my first peice of advise... scrap what you have and design it correctly and you can then do it with a normal query.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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