I am getting the following from a query

date|id1_|id2___|
1___|nick|james|
2___|john|nick_|

How can i convert this data this


id_____|date1|date2|
nick___|_1___|_2___|
john___|_1___|_____|
james_|_____|_2___|

Best Regards

Use the CROSSTAB query wizard, I think it will do what you want.

thank u for your time FoFa
i dont think this works for me
Crosstab gives me 2 name columns and i need only 1 with the combined results
Maybe I don't know to set the crosstab correctly.
any suggestions?
:(

Try to create a UNION query to normilize your data so you have one name per date. Then run the crosstab on the UNION query. (I hope your field not really is named DATE).
SELECT DATE, id1 from Mytable where id1 is not null
UNION ALL
SELECT DATE, id2 from Mytable where id2 is not null;

Thanks a lot FoFa
The UNION statement was the solution
after having them all in one column they were sorted out nicely with a crosstab query..

thanks for ur time and thoughts
take care
best regards