please need to get data from column into separate columns 1

[anthony777]

I have a download that sends a 2 columns of data that I need to get into different columns in a query for exporting

1 2
655 hotel
344 airport
565 car

I need to get these out by row one like
655 own field 1 row right next to it hotel
how can I do this plese.

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

I need to get these out by row one like 655 own field 1 row right next to it hotel"

What you describe here is what you already have -- "655 own field 1 row right next to it hotel"

But, do you want a field named 655 and a field named hotel?

I am confused!!!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[anthony777]

ok my fault I have a column with all the bill codes in them lets say 665 and then the billing rate which is 1.21 is right next to it good the problem is I need to extract from the same two colums 4 more codes lets say I need to also extract 334 and the bill codes assoctiated with it into separate columns in the same query so it would look something like this

column 1 2 3 4
665 1.21 334 1.74

this all comes out of the one column that has all the codes and the other single column that has the rates so it looks like

column 1 column 2
665 1.21
334 1.74

thanks

 

[SkipVought]

How is 665 related to 334?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[anthony777]

skipvought they are just different codes and rates that have to be in separte columns in other words it should look like this in query grids
code rate code rate code rate code rate
334 1.70 665 3.34 220 1.71 116 2.23

the columns look this
334 1.70
665 3.34
220 1.71
116 2.23

but have to be split out like above so I got to grab the code and rate that is mixed in one single column for code and one single column with matching rates and seperate them into their own column.

Thank You