Make-table query w/ an Index field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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];
 
James said:
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];
Click to expand...

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.
 
Back
Top