Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011

    Unanswered: HELP!! Need to convert columns into rows

    Hey All,

    I have a problem. I am trying to create a query from data that has been imported into my dbase but the information that I need is listed in columns instead of rows as such

    [ClientID], [Customer], [Aug 1, 13], [Aug 2, 13], [Aug 3, 13]...

    How do i get "Aug 1, 13" to become a row entry under a new column "Date" and the information from the "Aug 1, 13" cell become "TotalHours" as such

    [ClientID] [Customer] [Date] [Hours]
    1234 Doe, John Aug 1, 13 .4

    From this data i will need to convert the "Aug 1, 13" column name into ACTUAL Date and run a new query that adds more information about the customer to what i need above.

    Any help would be greatly appreciated.

  2. #2
    Join Date
    Nov 2011
    Forget the qry.Get your table structure fixed first. Maybe if you upload a sanitized copy of your db, compiled and zipped we can help.Along of course with a really good explanation of your needs.

Tags for this Thread

Posting Permissions

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