Hi
I'm totally new to VBA.
And I think I will be needing it a lot, the next upcoming half a year.
I know that I'm the kind of person only learning from experience.
Therefore I turn myself to you, experts.
So, first problem I walked into and I would like to solve through VBA:
A query I repeat 12 times, once for every month: I've got a table (CalcFirstYear) with 12 columns, named 1 to 12. And I've got a table with a lot of info per month per client (tbl_Retail_CM_2004)
Now I want to update info in the CalcFirstYear table with info from the specific/related tbl_Retail_CM_2004.Month column.
This is the query
Does anyone have any suggestion of how to resolve this in VBA?
With kind regards and thanks up front for any help,
Timoo
I'm totally new to VBA.
And I think I will be needing it a lot, the next upcoming half a year.
I know that I'm the kind of person only learning from experience.
Therefore I turn myself to you, experts.
So, first problem I walked into and I would like to solve through VBA:
A query I repeat 12 times, once for every month: I've got a table (CalcFirstYear) with 12 columns, named 1 to 12. And I've got a table with a lot of info per month per client (tbl_Retail_CM_2004)
Now I want to update info in the CalcFirstYear table with info from the specific/related tbl_Retail_CM_2004.Month column.
This is the query
Code:
UPDATE CalcFirstYear INNER JOIN tbl_Retail_CM_2004
ON CalcFirstYear.[Cust No] = tbl_xx_Retail_CM_2004.[Dealer]
SET CalcFirstYear.1 = [tbl_Retail_CM_2004]![Total Retails]
WHERE (((tbl_Retail_CM_2004.Month)=1));
Does anyone have any suggestion of how to resolve this in VBA?
With kind regards and thanks up front for any help,
Timoo