Results 1 to 4 of 4
  1. #1
    PATRICKPBME is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    171

    Report does not show all fields from query.

    I run a query which ends up displaying 19 fields with the information I need for my report. However, when I go to create a report from the query, only 15 fields are displayed. I have changed font size, paper size and orientation but it still does not display all fields in the report. Can't figure out why unless perhaps there is a setting somewhere limiting the displayed fields to 15?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Would have to examine report design. 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.

  3. #3
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Did you add more fields to the Query AFTER you created the Report after it?
    If so, those new fields will NOT be automatically added to your Report. You will need to add them in there.

    Either way, it is pretty easy to add new fields to your Report. Just open up the Report in Design View, and go to the "Add Existing Field" list and drag and drop the fields on your Report.
    If you do not see all the fields in there, then I suspect that your Report is not using the Query that you think it is. Check the "Record Source" property of the Report to see which Table/Query it is using.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Or perhaps the other 4 fields are:
    a) beyond the right hand edge of the first page so appear on a later page
    b) hidden (visible = false)

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

Similar Threads

  1. Replies: 3
    Last Post: 07-15-2015, 11:00 PM
  2. Replies: 4
    Last Post: 11-20-2014, 01:05 PM
  3. Replies: 3
    Last Post: 07-20-2014, 08:56 PM
  4. Replies: 2
    Last Post: 11-30-2013, 10:42 PM
  5. Dont show null fields in report
    By senna in forum Reports
    Replies: 4
    Last Post: 03-03-2011, 02:30 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