Crosstabbing Information

[crashz]

Trying to crosstab data fields in a table. I know how to do it in SQl but trying to see if the same thing can be done with access
CCINAMEADDREXP_DATEAUTORENEWSTATUSCNRT_TYPCNRT_NUMACCESS_BAARANK123Person1555 Roch St12/1/2008YTERMINATEDBAS366111114123Person1555 Roch St7/16/2008NTERMINATEDASA6331111111123Person1555 Roch St7/16/2008YTERMINATEDBAS6331111112123Person1555 Roch St8/13/2008YTERMINATEDBAS6337111113

Would there be a way to change this to being one row

[marianne]

i am not an expect on sql but base on what I observe on creating queries, it is the same in access and sql.

[crashz]

That came out garbled

# ADDR CD NUM RANK
123 333 Street ABA 1234 1
123 333 Street BAS 1234 2
123 333 Street BAS 3546 3

I want to know if there is an way in access to go through this data to produce

# ADDR CD1 NUM1 CD2 NUM2 CD3 NUM3
123 333 Street ABA 1234 BAS 1234 BAS 3546