Save report data to a table

K

Koulla

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

Thanks a lot.
 
N

Nikos Yannacopoulos

Koulla,

You are not very clear; is this an access report (in which case you already
have the data, so why store them again?), or an external report from some
other application, that you wish to import to Access? In the latter case,
you need to provide more information, like what app it comes from, the file
type etc.

Nikos
 
G

Guest

-----Original Message-----
Hi,
I have a report that contains data on it. I want that
data to save them on a table. How can I do that?
I have access 2002.

Thanks a lot.
.
Click to expand...
The data on that report come from many calculations and
subreports. I want to take and stored them in a new table
so that to use that data later for another use. I just
want to know if there is any way to do that.
 
A

Arvin Meyer

Data from a report cannot be stored unless it is in a query that underlies
the report. While you cannot store report data, you can duplicate it's
functionality in a form and save that. I suggest you don't do that.
Calculated data should not be saved in a relational database unless it is
required for history, or because the calculations take a very long time and
the data is recalled frequently.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
G

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.I try to use make query table
but the calculations does not appear properly. I mean I
have count(students) the result on the report is 14 which
is correct. When I try to save it to a make query appears
1 fouteen times.
Do you know how can I do that or any other way that can
help me with my problem??
I am using Access 2002.
Thanks a lot!!!
 
Top