Simple Rows to column Not so simple for me

[Carlos]

I have two tables that each record an ID, date, and a Value.
Ex. Table1. ID\date\ValueA and Table2. ID\date\ValueB
I would like to create a new table that joins these two tables in the
following way:
qry1. ID\date\ListofValues
1\10-9-2004\10
1\11-9-2004\20
2\9-15-2003\15
3\4-17-2005\20
3\5-17-2005\10
where for each ID with a value, a new row is created that lists its ID
and the corresponding value.

I read somewhere about the crosstab query but I don't think it is what
I'm looking for. Any suggestions?

 

[KARL DEWEY]

You can use an append query to get them in the same table or a union query
but I expect they will appear each time as below --
1\10-9-2004\10
2\9-15-2003\15
3\4-17-2005\20
1\11-9-2004\20
3\5-17-2005\10

You can sort them in a query to look like this --
1\10-9-2004\10
1\11-9-2004\20
2\9-15-2003\15
3\4-17-2005\20
3\5-17-2005\10

 

[Carlos]

Thank you, that did the trick.