Query

S

Sanj

I have following two tables in access for two differnt
months:
Jan Table:

Company frequency dollar
ABC 123 10
DEF 456 20
GHI 789 30

Feb Table:
Company frequency dollar
ABC 456 5
DEF 333 01
GHI 222 55

Can anybody tell me a query/how to link that will add
total for frequency & dollar for companies ABC, DEF & GHI
for two months.
That is
ABC 579 15
DEF 789 21
GHI 1011 85

THanks for the help
Sanj
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top