G
Guest
I have a table that I import from an outside source. This table contains
information on products by serial number. Because of the way it comes from
the original source, the serial numbers are often repeated with different
information attached. For instance the first occurance may have customer
name and address, the second may have the customer's email, phone and fax.
Is there an way to merger each of these occurances, so that the end product
does not have duplicate serial numbers?
I am using Microsoft Access 2000
Thanks
information on products by serial number. Because of the way it comes from
the original source, the serial numbers are often repeated with different
information attached. For instance the first occurance may have customer
name and address, the second may have the customer's email, phone and fax.
Is there an way to merger each of these occurances, so that the end product
does not have duplicate serial numbers?
I am using Microsoft Access 2000
Thanks