If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query that feeds the report
Im using Windows XP and Office 2003
I would like to put more than 255 fields in my report. I have one query that feeds my report. That query is full [255 fields]. If i take the query that is full and and make a relationship between it and another query that has a lot of unused field, will this allow me to put more than 255 fields in my report? If yes, how can i do this? Or how can i get more than 255 fields in my report? Thanks for any help ed -- thanks |
#2
|
|||
|
|||
Query that feeds the report
You can't get more than 255 fields in a report.
You can get 255 in a report and another 255 in a sub-report. You will have to figure out how to bind the sub-report to the main report. '================================================= === John Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County '================================================= === gambler844 wrote: Im using Windows XP and Office 2003 I would like to put more than 255 fields in my report. I have one query that feeds my report. That query is full [255 fields]. If i take the query that is full and and make a relationship between it and another query that has a lot of unused field, will this allow me to put more than 255 fields in my report? If yes, how can i do this? Or how can i get more than 255 fields in my report? Thanks for any help ed |
#3
|
|||
|
|||
Query that feeds the report
Thanks John
ed -- thanks "John Spencer" wrote: You can't get more than 255 fields in a report. You can get 255 in a report and another 255 in a sub-report. You will have to figure out how to bind the sub-report to the main report. '================================================= === John Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County '================================================= === gambler844 wrote: Im using Windows XP and Office 2003 I would like to put more than 255 fields in my report. I have one query that feeds my report. That query is full [255 fields]. If i take the query that is full and and make a relationship between it and another query that has a lot of unused field, will this allow me to put more than 255 fields in my report? If yes, how can i do this? Or how can i get more than 255 fields in my report? Thanks for any help ed |
#4
|
|||
|
|||
Query that feeds the report
"gambler844" wrote in message
... "John Spencer" wrote: You can't get more than 255 fields in a report. You can get 255 in a report and another 255 in a sub-report. You will have to figure out how to bind the sub-report to the main report. And, you may need to figure also how to further group the information so it can be understood and used by mere humans. 255 different fields is a lot of information to get one's head around, much less even more fields. You might benefit from reviewing some books on presenting data -- "Seeing Data" by Rebecca Riordan is a good one, and the principles put forth in Microsoft's books on the Windows Interface are useful, though if I recall correctly, they deal with on-screen viewing, not on-paper viewing (as is intended by a report, though you may only ever view it on-screen in Preview mode). Larry Linson Microsoft Access MVP |
Thread Tools | |
Display Modes | |
|
|