Hi,
I have two tables that I want to combine into a third (summary) table. I need a clue as to the steps necessary to do this. Thanks in advance.
Dennis
Table 1: Techs
Fields: Name 250 350 450 550
----- ---- --- ---- ----
Joe 10 11 12 13
Bob 11 12 14 16
for Joe 10 is the percentage commission rate for a sale where sale amount > $250 and < $350
for Bob 14 is the percentage commission rate for a sale where sale amount > $450 and < $550
Table 2: Sales data
Fields: Date Tech Sale_Amount
--------- ---- ------
1/1/2014 Joe $280
1/14/2014 Joe $360
2/2/2014 Joe $410
1/3/2014 Bob $380
3/2/2014 Bob $370
I want to end up with a summary table that has;
Fields: MonthYear Tech Sales Count Avg Rate
---------- ---- ------ ------ ---- -----
JAN2014 Joe $640 2 $320 10
FEB2014 Joe $410 1 $410 11
JAN2014 Bob $380 1 $380 12
MAR2014 Bob $370 1 $370 12
I've programmed before but never in Access.
Thanks,
Dennis