How to save a report as a Table or a Query

[miguel vasquez]

I have a report with some formulas, so I would like to convert this Report in a Table or Query.

PLease Help!!!

 

[Pat Hartman]

Usually you put your formulas in the query and use the query as the RecordSource for the report.

 

[miguel vasquez]

Hi Pat,

Thank you for your advice, but I created a formula to run a balance in a report, I did it in VBA using If statement and Variables. As far as I know I can not use variables in a Query. What I am doing now is Sending the report to my C drive as a Text and then import it back as a Table, but the file has 1.2 million rows, so it takes an hour to do it.

I don't know if I can use an Update statement to update a table.

Please let me know...

Thanks again!!!

 

[Pat Hartman]

You can add code in your report itself to write records to a file as they are formatted for the report but why would you ever do that? Calculated data should not be saved. It should be calculated as needed unless you are creating a data warehouse.