In the attached example I have used code to produce the desired output. I assume there will be a maximum of 6 entries for each source number.
See module mod_row_columns for the code
The database will open with a form displaying the input and output. Make a change to the Input data, then click on the Run Code button and the Output will re-display with the updated data.
Hi Poppa Smurf,
Thanks for Code. My input table is Big. Field1 has 60000 entries and max entries for any number is 60. I tried to do it with CrossTab Query. But I do not have the count with each entry. I mean if i can calculate Field1, like mentioned below.
Downloaded your file but could not open it. WinZip error message "does not appear to be a valid archive". Very interested .. . could you please re-post?
I have the same problem sometimes using Winzip in Windows 7. I use 7zip to open zip when I have problems using Winzip.
Anyway I have attached the file using 7zip. If you ahve problems contact me off list and I will send you the mdb file.
Note, this converts mutilple entries to one record as in the first posting in this thread. If you want to convert row and columns of an input table to columns and rows of the output table lookup Transpose on the Microsoft help, or I may still have an example for you.