-
Best solution
Hello all,
I am wanting to know the best option for the following problem:
I am doing a monthly process of updating a number of bank branch regions. The queries are from a table of data extracted from external database (no direct links) and another linked table with all current upto date branch details. the queries then put each months figures along the top and filter by an region (15 diff regions), once run they are then extracted manually to html and put on the intranet.
each month this process has to be repeated but there are only the last 24 months data in the table, so the headings in the static table (in the query) are different each month.
my questions are:
1. how can i get over the problem of the row headings changing each month and damaging my query.
2. can anyone think of a way of streamlining the whole process? i'm not very proficient at macros yet.
any advice would be very welcome.
-
Why use a static table? Sounds like a cross tab query might do the trick for you.
Also, why use static HTML? If you are running a Windows server, an ASP or ASP.Net solution would probably work better.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules