A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Query that feeds the report



 
 
Thread Tools Display Modes
  #1  
Old July 31st, 2007, 01:42 AM posted to microsoft.public.access.reports
gambler844
external usenet poster
 
Posts: 24
Default 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  
Old July 31st, 2007, 01:48 AM posted to microsoft.public.access.reports
John Spencer
external usenet poster
 
Posts: 2,364
Default 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  
Old July 31st, 2007, 02:28 AM posted to microsoft.public.access.reports
gambler844
external usenet poster
 
Posts: 24
Default 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  
Old July 31st, 2007, 05:50 AM posted to microsoft.public.access.reports
Larry Linson
external usenet poster
 
Posts: 3,112
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.