Hi I am Working Windows Appl .Net08.
My DB is Access Db.
The below image is from Access DB only.
In the image the table called Contacts having one of the column called 'ContactMedium'. In this Column having values like 'Mobile' , 'email'.
Now i want to saperate these values and create new columns in the same table.
How can make these values as a new columns ??
If i create Crosstab Query it giving error like Value type is not Aggr.
May i know the solution ??
Thanks
Last edited by malatesh kumar; Sep 23rd, 2011 at 03:42 AM.