Results 1 to 9 of 9
  1. #1
    LMcKee is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jun 2015
    Posts
    4

    Query based report not showing one table in "add field list"


    Hello,
    I'm an Access novice. I have a query based report that is based on several tables. All tables are joined by the same field "customer ID," but 1 table is not available under "Add Existing Fields." I cannot figure out why that table isn't available, but I need to add a field. Any advice would be greatly appreciated.

    Thank you!

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    If you need a field from a table, then that table must be included in your query.
    I a guessing that you have a query that uses many tables, and you are using that query as the recordsource of your report.

    From experience, your should adopt a naming convention that does not allow embedded spaces in field and object names. Use only alphanumeric and underscore("_") for names. It will save you many syntax errors.

  3. #3
    LMcKee is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jun 2015
    Posts
    4
    Thank you for the reply, Orange. Any ideas as to why one of my tables isn't even listed as available to grab fields? If I try to force it onto my report during the design it's saying it's coming from another table and then if I try to run the report it's treating the field as a report criteria and it's asking me to enter a value.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    If you want to provide db for analysis, follow instructions at bottom of my post.
    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.

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I suggest you take june7's offer.

    If the table in question is NOT part of your query, then that could be the issue.
    June will know when she reviews your database.

  6. #6
    LMcKee is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jun 2015
    Posts
    4
    My db contains tables that are linked external data files (xlsx and csv) that are updated by scheduled reports. I am unable to delete sensitive information. I can provide some screen shots of my report in design view and the field list with available tables and anything else that could be useful in assisting me find my error.

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I doubt that will help, but post whatever you want.

    Why can't you make a copy and delete info?

    Are the linked data involved in this issue?
    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.

  8. #8
    LMcKee is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jun 2015
    Posts
    4
    I see part of my issue, but I have no idea how i did this. Access "add available fields" is showing a table that contains 3 fields also contains all fields that are actually on the table I want to add. When I look at the actual tables they only have the fields they should, but the field chooser is attributing all fields in my Sales table to my Freight Invoiced table. I have no idea how I did this, but does anyone know how I fix it?

    Click image for larger version. 

Name:	Screen Shot 07-13-15 at 01.40 PM.JPG 
Views:	4 
Size:	96.5 KB 
ID:	21258Click image for larger version. 

Name:	Screen Shot 07-13-15 at 01.41 PM.JPG 
Views:	4 
Size:	35.3 KB 
ID:	21259Click image for larger version. 

Name:	Screen Shot 07-13-15 at 01.41 PM 001.JPG 
Views:	4 
Size:	53.0 KB 
ID:	21260

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    No idea.

    But why would Freight Invoiced have both CustomerName and CustomerID fields? Should just have CustomerID.

    I concur with orange - advise no spaces or special characters/punctuation (underscore is exception) in naming convention.

    Have you run Compact & Repair recently?
    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.

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

Similar Threads

  1. Replies: 3
    Last Post: 12-06-2014, 03:59 AM
  2. Replies: 5
    Last Post: 02-07-2014, 11:57 AM
  3. "Send Email" button on Query-Based Report
    By athyeh in forum Programming
    Replies: 5
    Last Post: 07-05-2013, 12:44 PM
  4. Export "Query or Report" to a "Delimited Text File"
    By hawzmolly in forum Import/Export Data
    Replies: 3
    Last Post: 08-31-2012, 08:00 AM
  5. Replies: 11
    Last Post: 03-29-2012, 02:32 PM

Tags for this Thread

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