Question data transform

[sandy70]

hi guys

anyone know how to transform this data

to this ??

any idea how to make it ???

 

[jdraw]

What exactly do these represent?
First looks like a spreadsheet, or a CrossTab; second looks like 4 database records.

You may get more info here
http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=25

 

[sandy70]

What exactly do these represent?
First looks like a spreadsheet, or a CrossTab; second looks like 4 database records.

You may get more info here
http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=25

this some data i got from my friend :

and this is what the table my friend want to make

 

[Pat Hartman]

To create the second table from the first requires 7 append queries. One for each of the code columns. If there are more columns in the table that we are not seeing, they will also need their own append queries. With only 7 columns, I would just create 7 queries. If you're talking dozens or more, I might consider creating and running the append queries in code.

 

[sandy70]

there is about 50 or 60 columns

 

[Pat Hartman]

The code solution isn't that bad. Use the fields collection of the tabledef to get the column names.

 

[sandy70]

The code solution isn't that bad. Use the fields collection of the tabledef to get the column names.

can u give more detail about it ??? or may be some example

still confuse about is

 

[Pat Hartman]

If I had had a code solution already built, I would have posted it. Create a loop that reads through the fields of the tabledef. You'll need to ignore fields that don't start with "Code". Then build an SQL string like the following and run it using DoCmd.RunSQL.

SQL = "Insert Into ( MyDate, Phone, CodeName, PackName) Select [Date], [Phone], CustID, " & strFieldName & ", " & strValue ", From YourTable;"