Save an expression within a query back to a table (1 Viewer)

[Agnister]

I created an expression of a certain fields in a query. I would now like to save all the fields including the expressions either back to the original table or to a new table. Is this possible?

 

[Trevor G]

Welcome to the Forum,

You could use a Make Table query and use your query and expression to do that.

 

[Agnister]

Trevor G
Thank you for your help. This worked fine. The only problem I encountered was that the expression data which appeared in the new created table was double precision and consisted of 11 decimal places. I changed it to single precision with 2 decimal places and the next time I ran the Make table query it was back to 11 places double precision. Any Ideas how to fix this?

 

[Trevor G]

In your query open the properties of the expression and then look at the format, set it to number and then set the decimal to 2 that should correct this for you.