Save report contents to a table

[Koulla]

Hi,
I have a report that contains data on it. I want that
data to save them on a table for later use. How can I do
that?
I have access 2002.

Thanks a lot.

 

[John Nurick]

Hi Koulla,

Normally there is no need to do this, because the data displayed by the
report already exists in the database and can be accessed with a query
in the ordinary way. What is the problem you are trying to solve?

 

[Guest]

I have a report that contains many subreports and
calculations. When I try to print that report an
error "cannot open any more tables" appears. I try
service Pack 2 and service Pack 3, also I download
JetEngine4.0 but the same error appears. That error is
because I have open too many queries and reports and many
calculations in one report. When I reduce the number of
queries or subreports in the report the error not
appears. But unfortunately I want tha info and must be on
the report so I think that if I find a way to store all
that info (that the report contains) in a table and then
create a simple report taking that info.I didn't find a
way to solve that problem. Do you know how can I do that
or any other way that can help me with that??
I am using Access 2002.
Thanks a lot!!!

-----Original Message-----
Hi Koulla,

Normally there is no need to do this, because the data displayed by the
report already exists in the database and can be accessed with a query
in the ordinary way. What is the problem you are trying to solve?

Hi,
I have a report that contains data on it. I want that
data to save them on a table for later use. How can I do
that?
I have access 2002.

Thanks a lot.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[John Nurick]

Hi,

One thing that might be worth trying is to create one or more temporary
tables containing data from your queries, and then base the report on
these.

But the experts on this hang out in microsoft.public.access.reports, so
I've crossposted this message there. Let's see what they suggest.

I have a report that contains many subreports and
calculations. When I try to print that report an
error "cannot open any more tables" appears. I try
service Pack 2 and service Pack 3, also I download
JetEngine4.0 but the same error appears. That error is
because I have open too many queries and reports and many
calculations in one report. When I reduce the number of
queries or subreports in the report the error not
appears. But unfortunately I want tha info and must be on
the report so I think that if I find a way to store all
that info (that the report contains) in a table and then
create a simple report taking that info.I didn't find a
way to solve that problem. Do you know how can I do that
or any other way that can help me with that??
I am using Access 2002.
Thanks a lot!!!

-----Original Message-----
Hi Koulla,

Normally there is no need to do this, because the data displayed by the
report already exists in the database and can be accessed with a query
in the ordinary way. What is the problem you are trying to solve?

Hi,
I have a report that contains data on it. I want that
data to save them on a table for later use. How can I do
that?
I have access 2002.

Thanks a lot.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.