slow query

[Chad]

I have an update query that updates a table with 50,000 records
(tblDailyvalues)

tblRegression has only 8 records

Is there a way to speed up this updated query? currently it takes longer
than a minute.

UPDATE tblDailyValues, tblRegression
SET tblDailyValues.Holiday_Value =
[tblRegression].[Factor]*[tblDailyValues].[Holiday]
WHERE (((tblRegression.Variable)="Holiday Factor"));

Thanks in advance for all o fyour help.

Chad

 

[Tom van Stiphout]

On Fri, 21 Nov 2008 11:31:02 -0800, Chad

Put an index on field tblRegression.Variable

-Tom.
Microsoft Access MVP