Hi Duane,
Thanks for your reply! My real intention was to create a form and a report that draw about 400 pieces of data from a query (which pulls data from many other queries). For now, what I see is an Access 2010 query can only handle about 255 fields, which means my form or reports can only contains 255 fields or less. I am trying to find a way to put more data on a report so that the users can have all of the information they need in one spot. For example, I wanted to create a "cheat sheet" that contains all important financial data of a company (Income Statement, Balance Sheet, and Cash Flow Statement) going back 10 years. With 255 field limitation. I can only have 25 row of data for the 10 years period.
For now, as work around, created several forms or several reports with each has fewer fields. I just thought SQL Server would give me more features.
From your email, it seems that since I use Access, it is the bottle neck.
One last question, do you know if there is anything out there that could replace Access as the Front End? I like Access so much because it is so easy to use.
Thanks again, Duane!
Tim
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar