Merging 2 rows in different table..

[ndcruz]

Hi Sir/Ma'am,

I need some help on how to do this in ms access query.

I have my 1st table like this table name: tb_1

Date_1 l Name_1 l Amount_1

01/01/14 l A l 45.00
01/01/14 l A l 100.00

2nd table name : tb_2

Date_2 l Name_2 l Amount_2



01/01/14 l B l 50.00
01/01/14 l B l 105.00


Now, I want to merge it in Query like this:

Date l Name l Amount

01/01/14 l A l 45.00
01/01/14 l A l 100.00
01/01/14 l B l 50.00
01/01/14 l B l 105.00

Can you help me please...... Thanks...
Please please please....

[orange]

You need to work with some tutorials on database/table design.

Try

select Date_1 as [Date],   Name_1 as [Name] , Amount_1 as [Amount] from Tb1
UNION
select Date_2 as [Date],   Name_2 as [Name] , Amount_2  as [Amount] from Tb2

[NTC]

so the rhetorical question is: why are they in separate tables?.... but the answer to what you seek is to write them into a common table. I don't know if you seek to do this permanently using one of the existing tables as the consolidation table - - or to write them both to a new table. One would use the Append Query in Access.