put more than 255 field on report from two tables

[billy_pit]

Hi,
My project is in MS Access 2002.
In that I want to generate Report which contain fields 258.I can put
255 fields but how can i add more 3 fields.
when i generate report for 258 fields than it will show msg too many
fields.
how can i solve this problem?

 

[Duane Hookom]

It is a bit unusual that you would need to use that many fields. However, you
can get around this limitation by using subreports.

 

[billy_pit]

Ya I know that this thing rarely happen but I have to do that
thing.Sorry but I can't use subreport for what I want to do,I don't
have any other option.Do u have any other solution then give me.By the
way thanks for ur help.

 

[billy_pit]

Ya I know that this thing rarely happen but I have to do that
thing.Sorry but I can't use subreport for what I want to do,I don't
have any other option.Do u have any other solution then give me.By the
way thanks for ur help.

 

[KARL DEWEY]

Why do you think you can not use subreports for your purpose?

If you explain the why then maybe someone can tell you a method that will
work for subreports.

 

[Larry Linson]

Hi,
My project is in MS Access 2002.
In that I want to generate Report which contain fields 258.I can put
255 fields but how can i add more 3 fields.
when i generate report for 258 fields than it will show msg too many
fields.
how can i solve this problem?

Reports don't "contain fields"... Reports are based on a RecordSource (Query
or Table), which does contain Fields, and display the Fields, and other
information, in Controls on the Report. A report is not limited to 255
Controls. Tables and Queries are limited to 255 Fields -- that is _not
optional_.

If you need to display 258 values, you are going to have to do something
other than expect a workaround to the 255 limit for Tables and Queries...
and, as the RecordSource of a Report only allows one Table or Query to be
specified, you need to find another way to obtain the data. Subreports have
been suggested because each Subreport Control can contain a Report which has
its own RecordSource, so the combination may total more than 255.

Give us information on what data you have, how it is organized, and how you
want to report it, and, even better, also explain what you are trying to
accomplish it rather than how you think you can or cannot accomplish it.

Larry Linson
Microsoft Office Access MVP

 

[Larry Linson]

I didn't say so in my initial response, but it is worth saying that
displaying that many values about a "something" generally does not result in
a useful, usable report and often indicates that the data layout was
improper.

Elsewhere, it was clear that you were not aware that a report could be based
on a Query... so perhaps you would benefit from visiting
http://office.microsoft.com, and following the hyperlinks for Training --
there are quite a number of good online training courses on a variety of
Access topics. They tend to be introductory-to-intermediate level, and aimed
at end-users rather than developers, but you should come out of them knowing
that a report's Record Source can be a Query as well as a Table. (and, did I
mention that they are free?)

There is also a good list of resource websites on the right-hand side of the
page at http://sp.ntpcug.org/accesssig/default.aspx.

Larry Linson
Microsoft Office Access MVP

 

[billy_pit]

 >> In that I want to generate Report which contain fields
 >> 258.I can put 255 fields but how can i add more 3 fields.
 >> when i generate report for 258 fields than it will show
 >> msg too many fields.
 >> how can i solve this problem?

I didn't say so in my initial response, but it is worth saying that
displaying that many values about a "something" generally does not result in
a useful, usable report and often indicates that the data layout was
improper.

Elsewhere, it was clear that you were not aware that a report could be based
on a Query... so perhaps you would benefit from visitinghttp://office.microsoft.com, and following the hyperlinks for Training --  
there are quite a number of good online training courses on a variety of
Access topics. They tend to be introductory-to-intermediate level, and aimed
at end-users rather than developers, but you should come out of them knowing
that a report's Record Source can be a Query as well as a Table. (and, didI
mention that they are free?)

There is also a good list of resource websites on the right-hand side of the
page athttp://sp.ntpcug.org/accesssig/default.aspx.

 Larry Linson
 Microsoft Office Access MVP

Thanks for ur replies ,I got my solution.