Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Location
    Los Angeles, California, USA
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Two Questions (Access 2000)

    Question #1:

    I use Access to clean-up the data and then import to Excel so that the data is user friendly and pretty; i.e., add graphs, etc. Hence, I am familiar with reports but, for my purposes, I find it somewhat cumbersome. That being said, is there a query that would allow me to do a subtotal?

    Question #2:

    I have three Excel files that are linked to an Access database. A co-worker told me that if I move the folder to a different location, the links to the Excel files will no longer work. If that were the case, would there be a way to re-link the Excel files?

    Thanks - GCB

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Two Questions (Access 2000)

    Question#2:

    Your co-worker is correct. The path to linked tables (which may be in another Access database, or in an Excel workbook, ...) is hard-coded and it is not relative. The Tools | Database Utilities | Linked Table Manager menu option lets you re-link tables interactively. If you want to do it in VBA, see MSKB article ACC2000: How to Relink Back-End Tables with the Common Dialog Control

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Two Questions (Access 2000)

    Question #1:

    If you want a query in Access to display something like the result of Data | Subtotals in Excel, forget it. That is not the way queries work. This functionality is provided by reports, which have extensive sorting and grouping capabilities.

    But if you want to clean the data in Access and then export (?) them to Excel, why do the subtotals in Access? I would use Data | Subtotals in Excel for that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •