Results 1 to 5 of 5
  1. #1
    trident is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    141

    Missing Table when creating a report

    I am trying to create a report from scratch. When I opened the tables where the data will come from, I cannot find 1 of the tables I need.



    I compared the Tables objects and the table field showed. all the table is appearing except for that 1 table i need. I opened a new report and the same thing happened, 1 table is missing and it is the same table.

    Can anyone enlighten me on this please.

    Trident

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Quote Originally Posted by trident View Post
    I compared the Tables objects and the table field showed.
    You can't find a table or you can't find a field in a table?

    I cannot replicate issue. If you want to provide db for analysis, follow instructions at bottom of my post. Identify the table/field.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I'm going with 'the table field isn't showing'
    I compared the Tables objects and the table field showed. all the table is appearing except for that 1 table
    but that is confusing for sure. The field width is probably zero. Open the table with the "missing" field and highlight all the visible fields. Right click and select "Column Width" and set to a number like 10. If it's still not visible, it must be hidden. Repeat right click and select "Unhide Columns"
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    trident is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    141
    Thank you all for your reply.

    To clarify, what is missing is the whole table.

    Trying to find a solution, I tried creating the report by using the missing table, and i was able to create a report using that table, however, when I included another field from a different table, it is now asking the connection. This is now where the problem crept again. The name of the table is not appearing but another table after that.

    I will try to put the whole object to show and find a solution.

    again, thank you for your assistance.

    Trident

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    It appears that the recordsource of your report is a multi-table query, and that some table is missing from that query.
    Might get more focused responses if you post a copy of the database.

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

Similar Threads

  1. Missing record on report
    By DougieJ in forum Reports
    Replies: 3
    Last Post: 11-23-2015, 05:16 AM
  2. Replies: 2
    Last Post: 03-02-2015, 03:06 PM
  3. Data in query table missing from report
    By nick.muir2 in forum Reports
    Replies: 2
    Last Post: 07-10-2013, 05:18 PM
  4. Missing data in report
    By newtoAccess in forum Reports
    Replies: 1
    Last Post: 12-01-2010, 10:40 AM
  5. Replies: 0
    Last Post: 08-01-2009, 12:43 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