How would I....
I have a query which produces a list like so:
REP Customer Date sold
--------------------------------
John S Ajax 1/1/05
John S Comet 1/5/05
John S Hotel 1/17/05
John s Miami 1/29/05
.....
John s San jose 3/14/05
John s Morgan Hill 4/1/05
Now I would I build a query to show for John S.
Agent 1st Account 5th Account 10th Account 20th
----------------------------------------------------------
John s 1/1/05 1/29/05 2/14/05 3/14/05
How do I do this?
Thanks
Rusty
I have a query which produces a list like so:
REP Customer Date sold
--------------------------------
John S Ajax 1/1/05
John S Comet 1/5/05
John S Hotel 1/17/05
John s Miami 1/29/05
.....
John s San jose 3/14/05
John s Morgan Hill 4/1/05
Now I would I build a query to show for John S.
Agent 1st Account 5th Account 10th Account 20th
----------------------------------------------------------
John s 1/1/05 1/29/05 2/14/05 3/14/05
How do I do this?
Thanks
Rusty