By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,234 Members | 1,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,234 IT Pros & Developers. It's quick & easy.

query error too many fields access 2007

P: 232
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
i also want to add that all fields are unique in both tables
May 7 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 100+
P: 2,321
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.
May 7 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.