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

  • Thread starter Thread starter Brandon
  • Start date Start date
B

Brandon

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:
 
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
 
Back
Top