I have a query that returns a top value from a table column:
I then uses that queries result to create a new table based on that result:Code:SELECT DISTINCT TOP 1 [MASTER DATA].Country FROM [MASTER DATA];
Is there a way to systematically name the Temp1 table as the selected [Article_Country].[Country] result from the first query?Code:SELECT [MASTER DATA].* INTO Temp1 FROM [MASTER DATA], Article_Country WHERE ((([MASTER DATA].Country)=[Article_Country].[Country]));