[AccessD] Update Query - Need to Speed It Up

Hi Rocky

Why are you doing this regular clean-up thing (which I guess it is)?
Wouldn't it be wiser to set these values when you append or manipulate
those records?

/gustav


> I am running an update query on a table with 2,500,000 records and it's taking just a bit too long for the my and the client's liking.
> The SQL is:

> UPDATE tblInvoiceDetail SET tblInvoiceDetail.fldInvoiceDetailPPV = """", tblInvoiceDetail.fldInvoiceDetailVariancePercent = 0;

> It's setting one field to blank the other to 0.

> Is there a way to make it run any faster?