Search Result

I have data in column A and i would like to copy 9 rows in that column then transpose the data in column I-R and and contunie to the next 9 rows and transpone again until it reaches the last row in column A. Then once the last part is reached delete column A AND B. I tryed to record a macro to do this but it wont loop on its own and keep going it stops after the first one the i have to press short cut key to move to the next one doing it like that...

Hi Guys,

I am a newbee to Bytes currently working on an MS Access database for one of my clients:

With respect, I'll get right to it:

I have 2 tables:
Table 1. TblTrip_Facts
Route Name , FactTypeId ,CustomerName ,RouteType
AISX1-0103 , 0 , TTMA , DEDICATED
AISX1-0104 , 0 , TTMA , DEDICATED


...

I am working with a query that has 6 columns and 101 rows; I would like to transpose the rows and columns. I have tried using a crosstab query but Access limits the row "fields" to 3 and this was not producing the desired output. I saw a comment in a thread about using a pseudo row field as a work around but I do not understand how this works.
Another option I tried is from the following link and attempting method 2: http://su...

I have been searching threads for a while and found the instructions listed below many times, however when I get to step 6 and select to save, I always receive the following error, "The information cannot be pasted because the copy area and the paste area are not the same size and shape". Does this function only work if the number or rows and number of columns are the same number? Does anyone have any suggestions for me? I greatly appreaciate...

Hi all,

I am using SQL 2000, and I have following table with 2 columns, ID and TIME

ID | TIME
A | 07:01
A | 12:05
A | 13:01
A | 15:09
B | 15:07
C | 06:52
C | 12:47
C | 17:03
D | 07:00
D | 18:12
D | 18:57
D | 21:04

Now i want to transpose them into another existing table with 7 fixed columns: ID, T1..T6
...