I will try the query out. Thanks.  I know, the duplicate data is a nightmare....

Ok, I hope this example works:

Table: Items

ItemID    UniqueID  Description

1               1          1 ct saphire ring

2               2         1 ct ruby ring

3               2         1 ct ruby ring

4               3         1 ct diamond ring

5               4         .5 ct amythist pendant

5               4         .5 ct amythist...

The problem is with the duplicates.  The query that Ron gave worked, but there are

still duplicate ItemFields, but unique DataIDs.

The problem is that the DataID is not unique, so the only distinct item is the ItemField in my example.  This field is only in the Items table, not ItemDetails.

Thanks,

Jennifer

Continued...

Most of the Information that I want to retrieve about the Item is in Items (Table 1)

ItemDetails (Table 2) has some additional information about the item, including the status.  Each...

Unlike the Northwind example, the CustomerID is only in Table 1.  The two tables

are connected by a DataID.

Table 1 has the ItemField, CustomerID, DataID

Table 2 has the StatusChangeDate, DataID, Status

Table...