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!!!

 

[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!!!