Results 1 to 3 of 3

Thread: MS Access Query

  1. #1
    Join Date
    Oct 2010
    Posts
    1

    Unanswered: MS Access Query

    Please help , I am pretty new to Query Side , I will explain my probem below with a sample Table (TABLE 1 with Fields Test ID , Role)

    Sample Data:

    Table 1
    Test ID Role
    1 AAA
    1 BBB
    2 AAA
    2 BBB
    3 D
    3 E

    My Case is , I just want to extract Unique records based on Role , For Example like above For Test ID 1 , Test ID 2 , Role are same . So i need to create a query to extract Unique records output like .

    Role
    AAA
    BBB
    D
    E

    Can any body help me how to create queries to extract records .ANy help is deeply appreciated

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    To select records you use a... that's right, a SELECT Query! And to pull only one record per each given value, you'd use DISTINCT.

    SO the SQL statement would be something like

    SELECT DISTINCT YourTableName.Role
    FROM YourTableName;


    Linq ;0)>
    Hope this helps!

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

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    to use that
    create a new query
    switch the designer to 'SQL view', usually thats a button on the far left of the toolbar
    then paste the code
    the run the query
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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