Results 1 to 3 of 3

Thread: ? (Acces 97)

  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ? (Acces 97)

    I have a linked spread sheet which I use as a report in Access. The ? I have is I have labels I use in the report which are based on the fields in the linked spread sheet. A few of these fields labels change from month to month on the spread sheet but not on the report. Can I have these labels on the report some how update to whatever my field names are on the linked spread sheet? Not sure if this makes sense but thought I'd try.. Thanks..

  2. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ? (Acces 97)

    You could link the cells into the report and use them as labels

    Copy the cell in excel, goto your report, Edit>Paste Special>Paste Link >Microsoft Excel Worksheet

    HTH

    Peter

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ? (Acces 97)

    Thanks Peter. That worked great!!!

Posting Permissions

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