Creating a Table Based On Two Records And Corresponding Field Values

[FALAGELOLOGIST]

I am a beginner at Access, can understand some basic VBA and I have a very tricky problem ahead of me.



I have one table with many records and many fields. For simplicity, here's a mini version.

Building Name	System1	System2	System3	System4
BLD1	System1A	System2C	System 3F	System4A
BLD2	System1B	System2B	System 3C	System4A
BLD3	System1A	System 2A	System 3C	System4C

In my real table there is about 1000 records and 25 Systems (fields)

I have a form with two subforms, each subform allows me to select one record from the table.

Let's say I selected BLD1 and Bld3, I want to create a button that will take the two selected records and create a table similar to the one below.

System	Bld1	Bld3
System1	System1A	System1A
System2	System2C	System 2A
System3	System 3F	System 3C
System4	System4A	System4C

(The actual end result would have about 25 records, one for each system.

What is the best way to go about accomplishing this?

[Perceptus]

If you have been able to create a query to join the data like you want, it should be a simple matter of just converting that select query to a make table query.

Are you trying to Transpose the Column and Row information? It sorta looks like thats what your doing. If this is indeed what you need, you may wish to handle the transpose function in excel.