Results 1 to 3 of 3
  1. #1
    newtoaccess123 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2011
    Posts
    2

    updating existing report with new data in table


    Hi everyone,

    I'm new to access and new to posting here, but hoping someone can help. I've inherited an access database for a volunteer project, and I'm trying to learn how to generate reports containing about 20 fields of information from a single table. The good news is the report is already created and formatted exactly as I need it. The bad news is, this was a year ago and much of the information in the table it is drawn from needs to be changed. I'm planning to wipe out the existing data from the table and import the correct data into the existing fields from an excel spreadsheet, but I need the report to update accordingly. So, how do I do this? So far when I change anything in the existing table nothing changes in the report. Thanks!

  2. #2
    pdebaets is offline Competent Performer
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Los Angeles
    Posts
    235
    You need to find out which table(s) are used as the report record source. Open the report in design mode, press Alt-Enter to toggle the property sheet open/closed. When open, find the Record Source property. That is where the report data is coming from. If it is a table, that's where you will find the data. If it is a saved query, open the saved query in design mode to find out more about it. If it is an SQL statement ("Select ... From ..."), the table(s) used will be listed in the "From" clause.

  3. #3
    newtoaccess123 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2011
    Posts
    2
    Thanks! I found it, and see that I was updating the wrong fields from the wrong table. Think I've got it working now. Thanks so much!

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

Similar Threads

  1. Replies: 11
    Last Post: 07-24-2012, 07:50 PM
  2. Updating table data while in use
    By crispy-bacon in forum Access
    Replies: 5
    Last Post: 06-03-2011, 12:49 PM
  3. Replies: 4
    Last Post: 05-30-2011, 08:20 PM
  4. Updating an Existing Table
    By jo15765 in forum Access
    Replies: 2
    Last Post: 11-21-2010, 09:11 PM
  5. Updating data within a form/table.....
    By softspoken in forum Forms
    Replies: 3
    Last Post: 04-15-2010, 06:33 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