Hi,
I'm relatively new to Access and completely new to Access Macros.
Every month I get 3 new reports (spreadsheets) that I import to an Access database. The reports are always identical in terms of field names, etc. The first thing I always need to do is create a query (link those 3 reports to a static (ie. unchanging) table with some references, and merge them).
The database is organised as follows (categories on the left hand side):
CommonTables
- static table
R1 (original reports from January)
- table A
- table B
- table C
R1_Queries
- Query 1 (merge between the static table and R1 table A)
- Query 2 (merge between the static table and R1 table B)
R2 (original reports from February)
- table A
- table B
- table C
R2_Queries
- Query 1 (merge between the static table and R2 table A)
- Query 2 (merge between the static table and R2 table B)
R3......
Hopefully, you can see the pattern. Each month I'm doing the same queries merging the static table with a report (the reports are the same each month in terms of field names). How can I automate it (save the steps?)
To be specific the things that I do in this query are:
- create links between this month's report and the static table (every month the same in terms of field names)
- choose the fields to be included
- insert a column (calculated field? concatenating two other existing fields)
Please advise.