Make-table query w/ an Index field

[Guest]

I have a make table query and want to have it create an index on one of the
fields it is creating at the same time. Here is my query, does anyone know
how to do this?

--------------------------------
SELECT [Unassigned_ARC].[ARC] INTO Unassigned_ARC_Bkgs
FROM Unassigned_ARC INNER JOIN AGENCY_REVENUE ON
[Unassigned_ARC].[ARC]=[AGENCY_REVENUE].[AGENCY_CD]
WHERE ((([AGENCY_REVENUE].[AMOUNT])>"0") And
(([AGENCY_REVENUE].[DATE])>=#1/1/2005#))
GROUP BY [Unassigned_ARC].[ARC];

 

[Rick Brandt]

I have a make table query and want to have it create an index on one
of the fields it is creating at the same time. Here is my query, does
anyone know how to do this?

--------------------------------
SELECT [Unassigned_ARC].[ARC] INTO Unassigned_ARC_Bkgs
FROM Unassigned_ARC INNER JOIN AGENCY_REVENUE ON
[Unassigned_ARC].[ARC]=[AGENCY_REVENUE].[AGENCY_CD]
WHERE ((([AGENCY_REVENUE].[AMOUNT])>"0") And
(([AGENCY_REVENUE].[DATE])>=#1/1/2005#))
GROUP BY [Unassigned_ARC].[ARC];

Can't be done from the query. Better would be to create the table ahead of time
with the index already built and then use an Append query instead of a MakeTable
query.