crosstab like query

[Guest]

I have two columns in a data file, Row_1 Column_1 contains a "WorkOrder"
column_2 contains an account number. Row_2 Column_1 contains the same
"WorkOrder" as Row_1 but Row_2 Column_2 contains a different account number.
I there any easy way of making a table that would be: Row_1 Column_1 the
duplicated "WorkOrder" Row_1 column_2 the first account and Row_1 Column_3
the second account number? Almost like a crosstab:
"WorkOrder: account#1 Account#2

 

[John Vinson]

On Wed, 29 Jun 2005 11:09:06 -0700, Pluggin Away <Pluggin

I have two columns in a data file, Row_1 Column_1 contains a "WorkOrder"
column_2 contains an account number. Row_2 Column_1 contains the same
"WorkOrder" as Row_1 but Row_2 Column_2 contains a different account number.
I there any easy way of making a table that would be: Row_1 Column_1 the
duplicated "WorkOrder" Row_1 column_2 the first account and Row_1 Column_3
the second account number? Almost like a crosstab:
"WorkOrder: account#1 Account#2

Well, it's not "like a crosstab" - it IS a crosstab.

You don't really want to store this (unnormalized) data in another
table, but you can certainly use the Query Crosstab Wizard to create a
query which will have exactly this appearance. The Query can then be
used as the recordsource for a report or form (though it won't be
updateable, of course).

John W. Vinson[MVP]

 

[Guest]

I have tried the crosstab wizard and i don't you need some other filed?

 

[John Vinson]

I have tried the crosstab wizard and i don't you need some other filed?

Nope. WorkOrder as the Row Header, AccountNumber as the Column Header
and *also* as the Value.


John W. Vinson[MVP]