Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report that don't change (2000)

    Hi I have a Report that is generated by groupID and transaction date. My problem is next year the groupId will change so I will not be able to generate this same report next year. I would like to save it as a word document and have that word document stay with that access database (embed it some how maybe). Or save it as a report in access that will not change as query that made it changes. Is this possible?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Report that don't change (2000)

    I don't know about the structure of your db, so I don't know what might be possible around your GroupId changing.
    But...
    One option is to convert a copy of the query that drives the report (assuming for the moment there is just one query) into a make table query. Then you will have a separate table containing a snapsot of the data was it was at that time.
    Then make a copy of the report using this new table as its recordsource. Then you will have a copy of the report that will not change.
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report that don't change (2000)

    Perfect ---your good
    Thanks so much

Posting Permissions

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