Transpose data

[aefv2010]

Hi,

Is there an easy way to transpose data from multiple tables, into a single row, using Access 2003?

Many thanks.

 

[vbaInet]

From multiple tables into a SINGLE row??? You're looking at hundreds or thousands of columns here.

But anyway, there's no transpose function in Access vba. I think you're denormalising having to consider transposing your data.

 

[aefv2010]

Hi vbaInet,

Thanks for your reply.

I may not have made myself very clear: I don't want to transpose an entire database, just data I extract from a query.

Any ideas would be greatly appreciated.

Many thanks

 

[vbaInet]

Transpose it to what exactly? Into one row?

What's the objective of this?

 

[aefv2010]

Tranpose the data into single rows for individual people (650 people altogether) in order to produce a single form for each person, containing just that persons individual data.

650 forms, with each form containing just 1 persons data.

 

[vbaInet]

You're approaching this the wrong way. How do you propose to manage 650 forms?

What is the idea behind this? You haven't given much information. There might be a better approach.