I get this from a query

date___ name
1_______1
2_______1
3_______2
4_______3
5_______4
6_______4

field date is unique while field name has
what can i do to get the following such that there are no duplicates for
the name field
_________________________________________________
| name | date1 | date2 | date3 | date4 | date5 | date6 |
-------------------------------------------------------|
|1 ____|1 ____ |2 ____| ____ | ______| ______| _____|
|------------------------------------------------------|
|2 ____| _____ | _____|3 ___ | ______| ______| _____|
|------------------------------------------------------|
|3 ____| _____ | _____| ____ |4 ______| _____| _____|
|------------------------------------------------------|
|4 ____| _____ | _____| ____ | _______|5 ____|6 ____|
|------------------------------------------------------|

Best Regards
manolo

Let the Crosstab Query Wizard take you through the process and build the query for you. Just select Queries - New - Crosstab Query Wizard.

thanks so much jfgambit
i spend so many hours trying to figure this out