Max number of fields

[DaveS]

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?

 

[Allen Browne]

No. Access is designed to work with relational data.

 

[Van T. Dinh]

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.

 

[Jeff Boyce]

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.

 

[DaveS]

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.

 

[Van T. Dinh]

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

 

[TC]

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