Hy!
I have one problem which I cant solve on my own.
Lets start from beginning...
I just started working at new job and I have one very confusing task to do every month in MSAccess.
I recive data for my database every month in excel.
I have to link new table for every new month (e.g. New_data_2016_02)and make querey to append that data to one larger table which have records of previous 6 monthes.
It looks something like this at the moment:
Tables:
· New_data_2016_01
· New_data_2015_12
· New_data_2015_11
· New_data_2015_10
· New_data_2015_09
· New_data_2015_08
· 6M_data à append of all tables (last 6 months)
Queries:
· 000 Deleting_6M_data à this is querey for deleting that large table
· Append_New_data_2015_08
· Append_New_data_2015_09
· Append_New_data_2015_10
· Append_New_data_2015_11
· Append_New_data_2015_12
· Append_New_data_2016_01
But tricky thing is that I have to add new table for each new month, also make corrections to previous 2 months and delete the oldest month.
Example:
· link new table: New_data_2016_02
· link again(corrections): New_data_2016_01
· link again(corrections): New_data_2015_12
· deleting table: New_data_2015_08
· make new querey: Append_New_data_2016_02
After linking new table, linking again 2 previous months, deleting and creating new query for new month, there goes Macro part of job.
I have to open design view of Macro, which begins with SetWarnings(No), and delete querey of 7th month which I dont need anymore and add my new querey. Save. Close. Run.
This is so retarded, so many steps for nothing! Its so much steps that I can c/p it faster direct in excel tables.
I hope you can understand what Im saying and sorry for my bad grammer and english J
I have one problem which I cant solve on my own.
Lets start from beginning...
I just started working at new job and I have one very confusing task to do every month in MSAccess.
I recive data for my database every month in excel.
I have to link new table for every new month (e.g. New_data_2016_02)and make querey to append that data to one larger table which have records of previous 6 monthes.
It looks something like this at the moment:
Tables:
· New_data_2016_01
· New_data_2015_12
· New_data_2015_11
· New_data_2015_10
· New_data_2015_09
· New_data_2015_08
· 6M_data à append of all tables (last 6 months)
Queries:
· 000 Deleting_6M_data à this is querey for deleting that large table
· Append_New_data_2015_08
· Append_New_data_2015_09
· Append_New_data_2015_10
· Append_New_data_2015_11
· Append_New_data_2015_12
· Append_New_data_2016_01
But tricky thing is that I have to add new table for each new month, also make corrections to previous 2 months and delete the oldest month.
Example:
· link new table: New_data_2016_02
· link again(corrections): New_data_2016_01
· link again(corrections): New_data_2015_12
· deleting table: New_data_2015_08
· make new querey: Append_New_data_2016_02
After linking new table, linking again 2 previous months, deleting and creating new query for new month, there goes Macro part of job.
I have to open design view of Macro, which begins with SetWarnings(No), and delete querey of 7th month which I dont need anymore and add my new querey. Save. Close. Run.
This is so retarded, so many steps for nothing! Its so much steps that I can c/p it faster direct in excel tables.
I hope you can understand what Im saying and sorry for my bad grammer and english J
