jpkeller55
Technical User
Appreciate any help with the following:
I have a table (FaxNum) with the following data:
LAST FIRST Fax
Smith John 666-333-2222
Jones Terry 666-333-2222
House Ray 888-999-1111
Blake Rob 888-999-1111
Johnson Sam 888-999-1111
White Barry 888-999-1111
Rio Jose 888-999-1111
I would like to run a query to return:
Fax Name1 Name2 Name3 Name4 Name5 Name6 Name7
203-737-5453 Jones, Terry Smith, John
205-975-9320 Blake, Rob House, Ray Johnson, Sam Rio, Jose White, Barry
Thanks!
I have a table (FaxNum) with the following data:
LAST FIRST Fax
Smith John 666-333-2222
Jones Terry 666-333-2222
House Ray 888-999-1111
Blake Rob 888-999-1111
Johnson Sam 888-999-1111
White Barry 888-999-1111
Rio Jose 888-999-1111
I would like to run a query to return:
Fax Name1 Name2 Name3 Name4 Name5 Name6 Name7
203-737-5453 Jones, Terry Smith, John
205-975-9320 Blake, Rob House, Ray Johnson, Sam Rio, Jose White, Barry
Thanks!