Results 1 to 3 of 3
  1. #1
    chr1stoper1 is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    55

    Populate a table from a report?

    Hi Guys

    Is it possible to populate a table based on infomation on a report ?



    I have a database which is working out cost savings after improvements on different jobs. I have it set up so so a set of queries run the calculations from a table and one piece of info from a form and then produces the report.
    I would like to populate a table with the savings of each job based on the figures that each report generates.
    Is this possible?
    Any help much appreciated

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Reports are fed data from tables/queries so just use that query to move data to another table. (Append query)

  3. #3
    Bullschmidt's Avatar
    Bullschmidt is offline Freelance DB Developer
    Windows 10 Office 365
    Join Date
    Mar 2020
    Location
    USA
    Posts
    64
    Or perhaps use code behind the report of the report's OnActivate to run an append query to add a record to a table...

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

Similar Threads

  1. Populate Report From Table
    By chalupabatman in forum Reports
    Replies: 18
    Last Post: 09-16-2017, 11:56 AM
  2. Replies: 29
    Last Post: 05-02-2017, 04:38 PM
  3. Populate Report with Table from Query
    By Ekhart in forum Reports
    Replies: 2
    Last Post: 08-26-2016, 08:21 AM
  4. Replies: 4
    Last Post: 12-09-2015, 09:02 AM
  5. Replies: 3
    Last Post: 03-11-2015, 12:36 PM

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