Stack records

[sazzysally]

Hi all

I wanted to know if it possible to create a new table query or multiple queries to stack data in a row from an existing table. Basically I have the bellow records in table 1

Car | Crash test 1 | Crash test 2
Ford PASS Fail
BMW PASS PASS
VW FAIL FAIL
MERCEDES PASS Blank
Ferrari FAIL Blank

create table 2 so the data looks like this

Car | Crash test |
Ford PASS
Ford Fail
BMW PASS
BMW PASS
VW FAIL
VW FAIL
MERCEDES PASS
Ferrari FAIL

thanks so much all xXx

[ranman256]

yes, in a macro you will add several queries
Q1 will append CAR, TEST1
Q2, append CAR , TEST2
etc...

[sazzysally]

sorry little confused how I would do that? do I need to create a blank destination table?

[ranman256]

Yes, or make the 1st query a make table.
the rest append qrys.