Query that feeds the report

[Guest]

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

 

[John Spencer]

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
'====================================================

 

[Guest]

Thanks John
ed
--
thanks

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
'====================================================

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

 

[Larry Linson]

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