query problem

[mita]

Hi
i have got two tables ..here is the sample data

table 1 for 2000
company serviceID vol Jan vol Feb vol mar .....voldec
qw 1 33 33 12
.................... 2 45...............


table 2 for 2001
company serviceID vol Jan vol Feb vol mar .....voldec
ac 4 33 33 12
.................... 2 45...............

how do i append table 2 to table one with the volumes for different years???


thanks

 

[strive4peace]

add a YR field to each table and use an append query

you really should consider, however, a stucture like this:

*Volumes*
VolID, autonumber
CompanyID, long integer
ServiceID, long integer
Yr, integer
Mnth, integer
Volume, number

*Companies*
CompanyID, autonumber
Company, text


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*