Recent content by 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.

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 :)

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

Hi, Thank you both for your help. I will implement your suggestions and see what happens. Thanks again :)

Hi GalaxiomAtHome, Thanks for your reply. I wrote this in Access 2003 design view - the SQL script that I posted was automatically generated. Can I still use your recommendations to change my script, or would I need to do something different? Thanks again :)

Hi, I'm trying to extract blank fields in a query. I have written the following script: SELECT dbo_dod_Person.Person_ID, dbo_dod_Person.Known_as_first_name, dbo_dod_Person.Known_as_surname, dbo_dod_Biog_sub_heading.Sub_heading...