PC Review


Reply
Thread Tools Rate Thread

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

 
 
Brandon
Guest
Posts: n/a
 
      15th Dec 2003

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...


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

 
Reply With Quote
 
 
 
 
Nikos Yannacopoulos
Guest
Posts: n/a
 
      16th Dec 2003
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...
>
>
>------------------------------------------------
>~~ Message posted from http://www.ExcelTip.com/
>~~View and post usenet messages directly from

http://www.ExcelForum.com/
>
>.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Eliminating records with duplicate fields, but not duplicate rows robert_dickey@hotmail.com Microsoft Access Queries 1 15th Sep 2006 03:34 PM
removing duplicate rows neowok Microsoft Excel Programming 1 17th Nov 2004 04:45 PM
removing duplicate rows dan graziano Microsoft Excel Programming 1 25th Sep 2004 12:16 PM
Removing rows with duplicate values in a field (distinct?) Brandon Microsoft Access Queries 3 23rd Dec 2003 02:22 PM
Re: Removing rows with duplicate values in a field (distinct?) Brandon Microsoft Access Queries 0 15th Dec 2003 10:30 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:41 PM.