Record Set Problem

[CGill]

I have a table with one field containing 11 records. I need to seperate these records out into fields therefore ending up with a table containing 11 fields and one record.

I sumise I need to step through each record and assign the value to a field but I lack the knowledge to do this.

Any help muchly appreciated.

 

[SkipVought]

Hi,

This is usually something that's done in a REPORT using a Pivot Table or Cross Sum.

It's generally not a good idea to de-normalize tables.

Are you familiar with data normalization?

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[CGill]

This is a one off so the fact it pulls the table apart is not a problem I do need to create a new table with the re formated data.

 

[SkipVought]

You can make a table from a crosssum.

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[CGill]

Can you explain how I do this please

 

[SkipVought]

What application are we talking about?

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[CGill]

MS Access I would guess it would need to be a select rst! type query in VBA or somthing ??

 

[SkipVought]

This one-of-a-kind thing ---

do you have to do it in CODE???

Why not design a new query in the GUI?

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[CGill]

I basically have 3000 emails which contain text I need to import in to access and store in fields, I have done the intial part of this by converting them into text fields and importing them into one large table.....the problem is I have one field with about 45000 records which I need to convert into 15 fields and 3000 records.

I open to suggestions so long as I end up with a table formatted as specified.

 

[SkipVought]

Please post an example of the data that needs to be transformed.

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[CGill]

Below shows how the data is held at present.....

Field1
c blakeman
blake2c
12/01/05
4556
see e mail recvd
see e mail recvd
see e mail recvd
John.Heffer Email
see e mail recvd
see e mail recvd
see e mail recvd

The data needs to be 11 Fields accross and 1 record down

Field1 | Field2 | Field3 | Field4| Field5 |
c blakeman| blake2c| 12/01/05| 4556 | see e mail recvd|

and so on......

 

[PHV]

The 11 Fields accross is consistent for the whole table ?
This table has only one field ? No autonumber ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[CGill]

Yes on both counts

 

[PHV]

Are you confident with Recordset ?
The basic idea is to create the new table with the 11 fields, read the input and write the ouput playing w<ith Mod 11.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244