Is it possible to split one table into multiple lines?

[jobdone]

I'm trying to help out my boss with ease of reporting.

He made a satisfaction database that tracks satisfaction in 2 ways, so we have:

Table

ID
SatisfactionAType
SatisfactionAScore
SatisfactionBType
SatisfactionBScore

I'd like to make a query that would split these into two lines, one for A, one for B and then export it to excel.

I'm not looking for the exact code or anything, just what I need to google for. I'm at a bit of a loss what exactly to search for in relation to the splitting part (I have some experience using VBA to export to excel, so I'm fine with that part)

Is it possible?

 

[namliam]

Make a simple query?

Or (re)think your design?

 

[jobdone]

I'd agree with the design rethink, but for now this is the hand I've been dealt.

What do you mean by simple query? Am I missing something super obvious? Because that happens to me a lot (See a previous thread where I forgot how subforms work)

 

[namliam]

Select Id, SatisfactionAType, SatisfactionAScore from table


Select Id, SatisfactionBType, SatisfactionBScore from table

etc...

Or even with a union...

Select Id, SatisfactionAType, SatisfactionAScore from table
Union All
Select Id, SatisfactionBType, SatisfactionBScore from table

 

[jobdone]

Ah, hadn't heard of Union All. Gave it a google, and it's exactly what I need.

As mentioned, I do tend to get lost thinking of more complicated answers to easy questions.

Thanks for the help!