put more than 255 field on report from two tables

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?

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

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


"billy_pit" wrote:

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?

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.

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.

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.
--
KARL DEWEY
Build a little - Test a little


"billy_pit" wrote:

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" wrote in message
...
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" wrote

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

On Jan 31, 3:38*pm, "Larry Linson" wrote:
"Larry Linson" wrote

* 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, did I
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.