Hi,
How can I Create a temporary from an existing table with a query?
can I add columns to the temporary table?
Hi,
How can I Create a temporary from an existing table with a query?
can I add columns to the temporary table?
Take a look at using a Make Table Query.l
See: http://office.microsoft.com/en-us/ac...010108505.aspx
You can add columns to it simply by adding new calculated fields in your query.