Is there a way - while in a query to refresh a table to display all the available fields?
The "table" is actually a query I am using as a table in another query. I modified the first query to add a field for quarter and then went in to the new table and it doesn't show query in the field list. I have several custom fields in these queries and don't want to re-attach the query (as a table) and start from scratch.....I know if I modify a table it will show the changes - but does this not apply when using a query as a table?
The "table" is actually a query I am using as a table in another query. I modified the first query to add a field for quarter and then went in to the new table and it doesn't show query in the field list. I have several custom fields in these queries and don't want to re-attach the query (as a table) and start from scratch.....I know if I modify a table it will show the changes - but does this not apply when using a query as a table?
