Results 1 to 2 of 2

Thread: Subquerie

  1. #1
    Join Date
    May 2006
    Posts
    1

    Unanswered: Subquerie

    Hi,

    I have a table with 4 fields (id, nomarxia, adt, moria)

    sample data follows..

    Table: DE

    id..nomarxia..adt.....moria
    1...Ath.......M1234....700
    2...Ath.......F5323....800
    3...Ait.......M1234....700
    4...Kav.......M1234....700
    5...Xan.......F5323....800
    6...Kav.......F5323....800
    7...Spa.......G5654....1000
    8...Xan.......L9876....1100
    9...Ait.......P2134....950
    10..Kav.......M1234....600

    For the selected condition---> WHERE adt = "M1234"
    I expect to get this result.

    nomarxia.moria.MAX_moria..MIN_moria..Count_id
    Ath......700...800........700...........2
    Ait......700...950........700...........2
    Kav......700...800........600...........3

    I know that is a subquery problem...As I am novice to this I would appreciate any help.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Never heard of a subquery, but what it sounds like you need is a Parameter Query. You run the query and it prompts you for a parameter, the adt number in this case, and returns all matching records.

    Open up Access and then click on Help. Enter parameter query in the box and then select:

    Create a parameter query that prompts for criteria each time it's run

    Then follow the instructions! If you have problems come back to your post and let us know. Don't get too impatient if it takes a while for an answer; it's the weekend, and a holiday weekend at that in the USA.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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