Re: ORDER BY in UPDATE



What use is an Order By in an Update Clause? The join field is either equal
or it's not, and reordering the fields won't change that.

<christianlott1@xxxxxxxxx> wrote in message
news:1172512220.290461.275260@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
UPDATE CLPROV_RANKED INNER JOIN Clean_Lqcn ON CLPROV_RANKED.PHONE =
Clean_Lqcn.Phoney SET Clean_Lqcn.PROV_ID = [SUBMID], Clean_Lqcn.
[Match] = "D", Clean_Lqcn.Class = "C", Clean_Lqcn.Rank = [Result]
WHERE (((CLPROV_RANKED.SUBMID) Like "CL" & "*") AND
(((LCS((UCase(NZ([PROV_ADDR2]," "))) & " " & (UCase(NZ([PROV_ADDR3],"
"))),(UCase(nz([DESCR1]," "))))>[Result]))=True));

I need to put an ORDER BY:

ORDER BY clprov4.Rank;

or

FROM clprov4
ORDER BY clprov4.Rank;

Access keeps giving me errors when I paste in the order by clause.


Christian



.