Max number of fields

I have a strange application where i need to place 389
fields on a report. Ideally the fields would come from
one big table. I have tried to join eight tables together
in a one to one manner, as soon as i exceed 255 fields
may code fails. I there any way of creating an
application where i can use 389 fields and print them on
a report?

No. Access is designed to work with relational data.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"DaveS" wrote in message
...
I have a strange application where i need to place 389
fields on a report. Ideally the fields would come from
one big table. I have tried to join eight tables together
in a one to one manner, as soon as i exceed 255 fields
may code fails. I there any way of creating an
application where i can use 389 fields and print them on
a report?

The Query which is the RecordSource of your Report is also limited to 255
Fields!

However, 255 Fields / Columns are much more than usually needed. In a
properly designed relational database, the Tables are usually long (lots of
Records) but very narrow (limited number of Fields). In fact, the widest
Table I have ever used had 33 Fields.

Perhaps, you should check out the Relational Database Design Theory and see
if it can be used in your database.

--
HTH
Van T. Dinh
MVP (Access)




"DaveS" wrote in message
...
I have a strange application where i need to place 389
fields on a report. Ideally the fields would come from
one big table. I have tried to join eight tables together
in a one to one manner, as soon as i exceed 255 fields
may code fails. I there any way of creating an
application where i can use 389 fields and print them on
a report?

Dave

You've not provided any details of what types of information would be
contained in your report. Nor, as the other responders have suggested, what
the relationships might be among your data elements.

Having a large number of data elements in a report does not mean you need a
large number of data elements in a table.

--
More info, please ...

Jeff Boyce
Access MVP

Thanks for your comment. I understand fully why you have
responded in the way you have.

Let me re-phrase the question.
What is the best way to create a report which is similar
to a VB6 Data Report, ie with header self numbered pages
auto sizing and footer, but which allows data to be
obtained using two or more queries?

I have used a Data Report but this only allows me to link
to a single query and hence 255 fields.

I am looking for a "report tool" which allows me to show
the information in a printable format which has been
taken from multiple tables using more than one query.


-----Original Message-----
The Query which is the RecordSource of your Report is
also limited to 255
Fields!

However, 255 Fields / Columns are much more than usually
needed. In a
properly designed relational database, the Tables are
usually long (lots of
Records) but very narrow (limited number of Fields). In
fact, the widest
Table I have ever used had 33 Fields.

Perhaps, you should check out the Relational Database
Design Theory and see
if it can be used in your database.

--
HTH
Van T. Dinh
MVP (Access)




"DaveS" wrote in
message
...
I have a strange application where i need to place 389
fields on a report. Ideally the fields would come from
one big table. I have tried to join eight tables
together
in a one to one manner, as soon as i exceed 255 fields
may code fails. I there any way of creating an
application where i can use 389 fields and print them
on
a report?


.

I haven't used Report/SubReport combination a lot but that is one avenue you
may want to look at.

--
HTH
Van T. Dinh
MVP (Access)




"DaveS" wrote in message
...
Thanks for your comment. I understand fully why you have
responded in the way you have.

Let me re-phrase the question.
What is the best way to create a report which is similar
to a VB6 Data Report, ie with header self numbered pages
auto sizing and footer, but which allows data to be
obtained using two or more queries?

I have used a Data Report but this only allows me to link
to a single query and hence 255 fields.

I am looking for a "report tool" which allows me to show
the information in a printable format which has been
taken from multiple tables using more than one query.

Maybe you might try creating seperate queries for a block of fields. Then create sub reports from these queries. Then you might be able to utilize the subform/subreport feature in the report design mode in the main report.

There's an example somewhere in Technet showing how to code an unbound,
multi-row report. (Sorry, I can't remember the reference.) Maybe that would
help.

TC


"DaveS" wrote in message
...
Thanks for your comment. I understand fully why you have
responded in the way you have.

Let me re-phrase the question.
What is the best way to create a report which is similar
to a VB6 Data Report, ie with header self numbered pages
auto sizing and footer, but which allows data to be
obtained using two or more queries?

I have used a Data Report but this only allows me to link
to a single query and hence 255 fields.

I am looking for a "report tool" which allows me to show
the information in a printable format which has been
taken from multiple tables using more than one query.


-----Original Message-----
The Query which is the RecordSource of your Report is
also limited to 255
Fields!

However, 255 Fields / Columns are much more than usually
needed. In a
properly designed relational database, the Tables are
usually long (lots of
Records) but very narrow (limited number of Fields). In
fact, the widest
Table I have ever used had 33 Fields.

Perhaps, you should check out the Relational Database
Design Theory and see
if it can be used in your database.

--
HTH
Van T. Dinh
MVP (Access)




"DaveS" wrote in
message
...
I have a strange application where i need to place 389
fields on a report. Ideally the fields would come from
one big table. I have tried to join eight tables
together
in a one to one manner, as soon as i exceed 255 fields
may code fails. I there any way of creating an
application where i can use 389 fields and print them
on
a report?


.