S
Stacy
Hi!
I am working with Access 2000 and I am trying to combine data for "same
customer" records into one customer record...
I receive a file from someone that looks similar to this:
lastname firstname address phone
smith john 123 St 555-1111
smith john 567 Dr 555-1212
I need to export a file showing only ONE John Smith but with both
Addresses and both phone numbers.
Something like this:
lastname firstname address phone
smith john 123 St; 567 Dr 555-1111; 555-1212
Is this possible?
If so, how do I go about getting my data to look like the above?
Thanks for any advice.
Stacy
I am working with Access 2000 and I am trying to combine data for "same
customer" records into one customer record...
I receive a file from someone that looks similar to this:
lastname firstname address phone
smith john 123 St 555-1111
smith john 567 Dr 555-1212
I need to export a file showing only ONE John Smith but with both
Addresses and both phone numbers.
Something like this:
lastname firstname address phone
smith john 123 St; 567 Dr 555-1111; 555-1212
Is this possible?
If so, how do I go about getting my data to look like the above?
Thanks for any advice.
Stacy