var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: HELP!! Need to convert columns into rows
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.
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