Results 1 to 13 of 13

Thread: Access DB Row Values into Columns

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    May 2010
    Posts
    229

    Access DB Row Values into Columns

    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
    Attached Images Attached Images  
    Last edited by malatesh kumar; Sep 23rd, 2011 at 03:42 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width