union tables

[JoanaSantos]

i have two tables:

month1
Fec_Data - Fec_Ficheiro - CC1 - Total1
1 22
2 25
4 30

month2
Fec_Data - Fec_Ficheiro - CC2 - Total2
2 25
3 27


i want to have a third table with the following information:

preparar_mes
Fec_Data - Fec_Ficheiro - CC - Total1 - Total 2
1 22
2 25 25
3 27
4 30


i want to group the CC from month1 and month2... and have a column for total1 (month1.Total) and another for total2 (month2.total)

can you help ?

 

[SkipVought]

Hi,

Have no idea what your headings represent except Total.

What happens when month3, 4, 5 etc.?

 

[dhookom]

JoanaSantos,
Is this an Access query question or Excel or what?

Please use the TGML Pre tag to display your data. I can't make any sense out of column/field names or values
[pre]month1
Fec_Data Fec_Ficheiro CC1 Total1
1 22
2 25
4 30[/pre]

Duane
Hook'D on Access
MS Access MVP

 

[JoanaSantos]

sorry i was using access queries.

but i already solve the problem
thanks

 

[SkipVought]

Please post your solution for the benefit of other members.