Random Selection of a duplicate

[nodge87]

I am trying to select ONE instance of any duplicates in my table. EG: I have a table with various information for duplicate serial numbers. (Serial Number, description, date, ID, Amount)

I am totaling up the, "Amount", fields for each serial number and i want to display the total in one line relating to the serial number. However, i want information to populate the "Description", "Date", and "ID" fields also. The problem is that there is differing info in each of the duplications in the first place.

For the totalled up serial number record i dont care which set of information populates the fields... So what I am asking is..... is there a way of selecting a random instance of the duplicates to take that info from the irrelevant fields and popluate a single totalled up record.

Hope that is somewhat clear!!

Thanks for any help!!

[HiTechCoach]

This may help:

Subquery basics