Search results

  1. M

    Appending many tables together while creating a new field for pivot tables

    A large union query worked great, and the key piece I needed was being able to do "RegionA" as RegionName, "2001" as DataYear ". Select ..., "RegionA" as RegionName, "2001" as DataYear From tblRegionA2001 UNION ALL Select ..., "RegionA" as RegionName, "2002" as DataYear From tblRegionA2002...
  2. M

    Appending many tables together while creating a new field for pivot tables

    Hello, I received a database with many tables that are by year and region, with identical layouts. For example, tblRegionA2001 tblRegionA2002 tblRegionA2003 tblRegionB2001 tblRegionB2002 tblRegionB2003 I'd like to combine these in a way that I can use a pivot table to summarize the data in...
  3. M

    Replace a Table

    This has worked swimmingly. No changes required. Thank you very much for the hand.
  4. M

    Replace a Table

    Hi, I have a large numbers of text files I'm sent regularly as they are changed/updated. I import them and replace the old ones, run some queries that are already written in Access and produce what I need. I was trying to find something to speed up the import process, and so I used the code...
Back
Top Bottom