S
Steve
Got a bit of a brain teaser. I have a one to many query
that is giving me some duplicate data because of the many
side of the query(I am only using one of the fields from
the many side). Anyone know how to take the many side of
the query and create additional fields at the end of the
query so that I only have one unique record for each
instance? Example
This is what I get:
Name Address Phone Number
John Smith 123 East Street 111-111-1111
John Smith 123 East Street 222-222-2222
This is what I want:
Name Address Phone Number Phone Number
John Smith 123 East Street 111-111-1111 222-222-2222
Any ideas???
Thanks,
that is giving me some duplicate data because of the many
side of the query(I am only using one of the fields from
the many side). Anyone know how to take the many side of
the query and create additional fields at the end of the
query so that I only have one unique record for each
instance? Example
This is what I get:
Name Address Phone Number
John Smith 123 East Street 111-111-1111
John Smith 123 East Street 222-222-2222
This is what I want:
Name Address Phone Number Phone Number
John Smith 123 East Street 111-111-1111 222-222-2222
Any ideas???
Thanks,