Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006
    Posts
    3

    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.

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    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.

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums