query error too many fields access 2007

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kkshansid
    New Member
    • Oct 2008
    • 232

    #1

    query error too many fields access 2007

    hi
    i need to prepare a report in access 2007 with the help of joining three tables where each table contain around 150 fields but even the join of two table results error that too many fields defined. in this situation i cant even think of joining third table.kindly suggest me how can report be prepared?
    access 2007,window7 or xp same problem
    thanks
    i also want to add that all fields are unique in both tables
    Last edited by kkshansid; May 7 '12, 06:38 PM. Reason: addition
  • TheSmileyCoder
    Recognized Expert Moderator Top Contributor
    • Dec 2009
    • 2322

    #2
    A table (or a query) can contain at max 255 fields. If the reports share a common key, you could make a main report based off the key, with each table being represented as sub-reports.

    Comment

    Working...