Results 1 to 6 of 6
  1. #1
    Huddle is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    318

    Report - Too Many Fields Defined - Expression Error


    I have a Summary Report with appoximately 250 unbound fields that will have count expressions. It was working fine until I entered the last set of expressions and now when I try to run the report it tells me there are "Too many fields defined". All this report does is count various data to summarize that database. What can I do?

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Make two subreports and put half the fields on one and half on the other, then put them next to each other on the report?

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,795
    Subreport was what I did to get around this limitation, although I only needed one subreport, left the other data on the main report.
    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.

  4. #4
    Huddle is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    318
    I got it to work with a sub report. My problem now is it should be two pages but it is over 2000. It keeps printing the the sub report over and over.

  5. #5
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Hi -

    Probably because you have put the sub-report in the detail section of the report, so it prints it once for each record. Move the subreport to the report or group header.

    John

  6. #6
    Huddle is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    318
    That worked. Thanks

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

Similar Threads

  1. Compile error: Variable not defined
    By HarryScofs in forum Access
    Replies: 8
    Last Post: 07-25-2011, 09:06 AM
  2. Application-defined or object-defined error
    By hawkins in forum Access
    Replies: 6
    Last Post: 07-01-2011, 01:57 PM
  3. Too many fields defined??
    By stryder09 in forum Access
    Replies: 1
    Last Post: 04-08-2011, 11:00 AM
  4. "Too many fields defined" error
    By Matthieu in forum Queries
    Replies: 1
    Last Post: 01-28-2010, 08:55 PM
  5. Error: "User-defined type not defined"
    By mastromb in forum Programming
    Replies: 10
    Last Post: 01-08-2010, 02:57 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