Combining multiple records

M

Mark F

I have a big problem and hoping someone can help me out.

I've created a database with two linked tables - one showing individuals
(urn / name / postcode / dob / etc), the other table shows transactions (urn
/ date / value / descr / etc) - which have a separate urn as well as
contianing the individuals urn.

I've linked the two tables in access so I can see all the transactions an
individual has made - but need to run some analysis and wanted to put it into
a pivot table etc on excel - so i I need to create a new table which takes
the core info on the individual and takes the details of each transaction and
appends it to the record so i get something like this

URN / surname / dob / sex / trans urns#1 / value / date / trans urn
#2.......etc

the problem i've got is some people have upto 90 transactional records so
will need all info in one row - so the table will need a lot of columns.

Hope someone can help!

cheers

m
 
M

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You are incorrect about the set up of you query. Set up the query with
results like this:

URN surname dob sex trans urns value date
URN surname dob sex trans urns value date
URN surname dob sex trans urns value date
URN surname dob sex trans urns value date
.... etc. ...

Then in Excel use the Pivot Table wizard to select the query from the
Access DB. Put the "Trans Urns" as a Column and the "value" as the Data
(be sure to select what type of calculation you want on the value). Put
the other columns in the Row section.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSTgryYechKqOuFEgEQKKjgCgspaz0qsBi66HlKZD6T50geMbK5QAoJkf
aYyNW8uGf9CHC4DXQaX1wFZ0
=KTHH
-----END PGP SIGNATURE-----
 
Top