How do I Select DISTINCT from 1 field only

[raymond.allan]

Hi,

Using Access 2000

No code modules are in the mdb ...

I have a linked DBF file which contains duplicate data I do not want
to see but not all fields will be the same.

I append 3 fileds and only want to see unique data from the appended
field, summing the fields that do not match is not an option

TIA

Raymond Allan

 

[John W. Vinson]

Hi,

Using Access 2000

No code modules are in the mdb ...

I have a linked DBF file which contains duplicate data I do not want
to see but not all fields will be the same.

I append 3 fileds and only want to see unique data from the appended
field, summing the fields that do not match is not an option

TIA

Raymond Allan

Not sure I understand the problem!

A SELECT DISTINCT query - or, equivalently, viewing the query's Properties and
setting the Unique Values property to True - will hide all duplicates for the
fields included in the query.

What are you "appending" the fields to?

John W. Vinson [MVP]

 

[raymond.allan]

Hi John,

There are 24 fields in the database

I append 3 of them, Order Number & Part Number & Operation Code

There are 3 fields with a quantity, Rpi Qty, Qty Short and Qty Balance

Example:with the Appended field being the same on each row

New Filed Name Rpi Qty Qty Short Qty
Balance ....................
1 Appended Field 3.0 52 0
2 Appended Field 1.0 25 0
3 Appended Field 2.0 52 0

The Rpi Qty can sometimes be all the same

On the above I would only want to see row 1 in my report

Rgds
Raymond Allan

 

[John W. Vinson]

There are 24 fields in the database

The dBase database/table?

I append 3 of them, Order Number & Part Number & Operation Code
There are 3 fields with a quantity, Rpi Qty, Qty Short and Qty Balance

Example:with the Appended field being the same on each row

New Filed Name Rpi Qty Qty Short Qty
Balance ....................
1 Appended Field 3.0 52 0
2 Appended Field 1.0 25 0
3 Appended Field 2.0 52 0

The Rpi Qty can sometimes be all the same

But sometimes different.

On the above I would only want to see row 1 in my report

WHICH ONE? How can Access tell if the desired Rpi Qty should be 2.0 or 3.0 or
1.0? How can Access tell if Qty Short should be 52 or 25? Could you explain
why you want to import three rows of data and then discard two-thirds of it?

What is this report intended to accomplish???

John W. Vinson [MVP]