Query that feeds the report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
'====================================================
 
Thanks John
ed
--
thanks


John Spencer said:
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
Click to expand...
Click to expand...
 
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
 
Back
Top