Output report to a table with added data

[BSman]

I'd like to send every line of a selected report to a table and also include additional data at the beginning of each row of data. If necessary I can do something within each report for the added data. My primary question is if it is possible to send each line of a report to a table (as a row of that table) and, if so, how do you do it? My objective is to create a table that contains every line of the report as a field, plus other fields with a report identification code, a page number, and one or more fields that would be used for security controls (let's say a location code). Then the table would be used as a source for other users to be able to view/print the portions of the report (locations) that they have the rights to see. At the same time, the report would only have to be prepared once. I'm working with Access 2000/2003 with a SQL Server back end for the applications.

 

[mp9]

Why not just create a make-table query with the same SQL as your report's source?

 

[BSman]

Writing to a table might be an alternate solution if there is no way to do what I would like to do, but I'm looking for a way to avoid any processing, other than to only permit the user to view the pages of the report he has the rights to see. Otherwise all of the computed fields on the report would have to be created.

Ideally, if the report could be written into a table (maybe each page as a memo field in a table?) then the appropriate pages of the report could be viewed with a browser front end.

Bob