Update Access field, SQL operator

[Frec]

I'm trying to update a field in Access.

Here's my code:

<CFQUERY>
SELECT * FROM tblFinal WHERE Field0='L' AND Field1 = 'ID 123 000 000'
</CFQUERY>

<CFSET FIELD1NUM = #NumberofRecords.FIELD11#>
<CFQUERY>
UPDATE tblFinal SET FIELD1= ' ID 123 000 001' WHERE Field1='ID 123 000 000'
AND Field0='L' AND Field11num > '99'
</CFQUERY>

[paross1]

Is there a question here, or some sort of error that you are getting? If so, you might want to post more information.

Phil