Can I create a new table from a report?

[Koden]

Hello,

Is there a way I can create a new table based on a report? I know I
can do it with a query but I have to format data using a report. I
also know I can just dump the report to excell and then import but the
report results in more than 65000 lines of data (more like 240K) and I
dont really want to break it out into multiple excell spreadsheets.

Hopefully it is just something simple I missed.

Here is the setup I am working with..

Single database with multiple tables (linked to our accounting
database)
Single query pulling the required fields out the the multiple linked
tables
Single report to name the headers and do a line count on a group


Thanx
Mark

 

[Jeff Boyce]

Mark

Why? As in "why do you feel you need a table based on how you've formatted
data in a report?" Or "what business need are you trying to solve with this
approach?"

It may be that there are other solutions than duplicating all your data into
a new table...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[doodle]

Copy the query that your report is based on and change it to a make
table query.

-doodle

 

[Koden]

I would but I need to do a running total on a group to add a line
number column.

 

[Koden]

We are doing a data conversion from and old accounting system to a new
one. I am pulling the data out of our old system using an ODBC
Connection using access. Our new system requires that we have a line
number for each order (if the order has 3 line items we need to add a
1,2,3 to a new colum in the order). I cant see any way of doing this
in a query. I also need to rename the colum headers to match the new
system so the import will work.

I realise that SQL is probably a much better tool but I am working with
what we have.

Thanx for the help.
Mark