Query For Data Export Version: 2007

[PC User]

I have two tables that are linked by a key field that I need to export for uploading onto a website database:
Chemical Properties
Chemical Components
key field: ChemicalID

I need help in developing a query or an output report to export the chemicals with their properties and the components from the other table. This may not be as simple as just making a query. Each chemical has 3 or more components and currently they are linked to one chemical.

To make a file to transfer to the online database, the chemical and all the components have to be in the same record. Right now the data exists as each record in the chemical table linked to several records in the component table. I don't know how to program the database to put the linked chemicals and their components on the same record. Has anyone confronted this problem before?

I've made as sample spreadsheet to show how the chemicals and their properties will look in the spreadsheet used to upload the data. Please look at the attachment before commenting.

Thanks,
PC

 

[georgedwilkinson]

You are requesting a way to denormalize your data for the outside world to view, I believe?

Look up cross-tabulated (or cross-tab) query in Access help. Not a simple thing, but doable.

 

[PC User]

Query For Data Export Version: 2007

Seems like you're not the only one complaining about this website database. Why they designed it this way, I'll never know. Your help is appreciated.

Thanks much,
PC