Calculated Field In Table-Query-MakeTable Issue

[Lisa Perry]

Hello,



I have a table that calculates several other fields within that table. I need to provide this data to my manager in Excel with that calculated field - Total Invoice.

I developed a query pulling that field in and it ran fine but when I tried to change the query type to a "Make-Table" so I can have a new table with that data and be able to design a macro to export it to Excel - it would not run as it says...

"A calculated column cannot be saved without a valid expression in the Expression property"

I am not sure what to do here - would someone be able to help?

I thank you for any help.

Thank you.

Lisa

[JoeM]

Why are you trying to write it back to a Table? You can export a query to Excel just as easily as you can a Table. So there may not be any need to write the information back to a Table.

[Lisa Perry]

Thank you. I was using the wrong action in the Macro - I should have selected Export with Formatting and that allows for a Query - I had selected Import/Export Spreadsheet which does not ... it works great.

Thank you for the help....

Lisa