Duplicate query question

[Mikey B]

I have a table with Package#, Reference#, PartLocation, and PartDescrip.
I am trying to find distinct records of Package# and inlcude all the other
information with it.
The problem is Package# has several locations, so the duplicate records are
not weeded out. I really don't care what is in the location field since any
of the locations will reference back to the same invoice, but one of the
locations needs to be listed. I would accept just the first location found.
I don't know how to make it show the field without making it count for
distinct records.

Any help would be appreciated.

 

[KARL DEWEY]

Create a totals query with Package#, Package#, PartLocation as fields.
Change the Group By on the second Package# to Count with criteria >1 and
Group By on PartLocation to First.

 

[Mikey B]

Thanks. That works perfectly.

Create a totals query with Package#, Package#, PartLocation as fields.
Change the Group By on the second Package# to Count with criteria >1 and
Group By on PartLocation to First.