Removing rows with duplicate values in a field (distinct?)

Discussion in 'Microsoft Access Reports' started by Brandon, Dec 15, 2003.

  1. Brandon

    Brandon Guest

    Hi everyone,

    This may be a noob question but I am desparate for guidance on this
    matter. I want to query some fields from my database but only the ones
    with unique 'Chip Designator' values.

    For example, my database looks like this:

    | STD of Data | Wafer | Chip Designator | Date |Image
    | 1.04 | X13 | Chip TB | 12/10/03 | DB4
    | 1.99 | S59 | Chip C4 | 12/03/03 | DT9
    | 1.56 | S57 | Chip B7 | 12/04/03 | DB8
    | 1.34 | X13 | Chip TB | 12/10/03 | DB2
    | 1.04 | S59 | Chip C4 | 12/03/03 | DB5


    I want my query to retrieve data looking like this:

    | STD of Data | Wafer | unique_chip_desi | Date |
    | 1.04 | X13 | Chip TB | 12/10/03 |
    | 1.99 | S59 | Chip C4 | 12/03/03 |
    | 1.56 | S57 | Chip B7 | 12/04/03 |


    Please help...:confused:


    ------------------------------------------------
    ~~ Message posted from http://www.ExcelTip.com/
    ~~View and post usenet messages directly from http://www.ExcelForum.com/
     
    Brandon, Dec 15, 2003
    #1
    1. Advertisements

  2. Brandon,

    Make a new query (or work on the existing one, if this is
    where your records come from). Select for output all
    fields but Image and then press the button with the
    summation symbol on the toolbar to make it a Totals query.
    You will notice that there is now a new line in the grid,
    labelled "Totals", and the default setting for all fields
    is Group by. Change it to First foir the STD of Data field
    and you're done.

    Nikos
    >-----Original Message-----
    >
    >Hi everyone,
    >
    >This may be a noob question but I am desparate for

    guidance on this
    >matter. I want to query some fields from my database but

    only the ones
    >with unique 'Chip Designator' values.
    >
    >For example, my database looks like this:
    >
    >| STD of Data | Wafer | Chip Designator | Date

    |Image
    >| 1.04 | X13 | Chip TB | 12/10/03

    | DB4
    >| 1.99 | S59 | Chip C4 | 12/03/03

    | DT9
    >| 1.56 | S57 | Chip B7 | 12/04/03

    | DB8
    >| 1.34 | X13 | Chip TB | 12/10/03

    | DB2
    >| 1.04 | S59 | Chip C4 | 12/03/03

    | DB5
    >
    >
    >I want my query to retrieve data looking like this:
    >
    >| STD of Data | Wafer | unique_chip_desi | Date |
    >| 1.04 | X13 | Chip TB | 12/10/03 |
    >| 1.99 | S59 | Chip C4 | 12/03/03 |
    >| 1.56 | S57 | Chip B7 | 12/04/03 |
    >
    >
    >Please help...:confused:
    >
    >
    >------------------------------------------------
    >~~ Message posted from http://www.ExcelTip.com/
    >~~View and post usenet messages directly from

    http://www.ExcelForum.com/
    >
    >.
    >
     
    Nikos Yannacopoulos, Dec 16, 2003
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Amanda Redmond-Neal

    count only distinct values despite multiple appearances

    Amanda Redmond-Neal, Aug 28, 2003, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    202
    GVaught
    Aug 28, 2003
  2. Sue

    Count distinct values

    Sue, Oct 30, 2003, in forum: Microsoft Access Reports
    Replies:
    4
    Views:
    180
  3. Andre Uys

    Count Distinct Values

    Andre Uys, Aug 1, 2004, in forum: Microsoft Access Reports
    Replies:
    3
    Views:
    200
    Ken Snell
    Aug 1, 2004
  4. Meryl

    Counting Distinct Rows

    Meryl, Sep 3, 2004, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    134
    Allen Browne
    Sep 3, 2004
  5. Guest
    Replies:
    1
    Views:
    8,417
    Larry Linson
    Feb 24, 2005
Loading...

Share This Page