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
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