flagging every tenth record

[jlnewbie]

I have a query where I'm able to select every tenth record using *0. Now I want to flag only those record with a sting saying "QC". Is this possible?



JLopez
Lopez31@ATC-Enviro.com
Environmental Services @ Your Service

 

[abaldwin]

I take it from your question that you have an autonumber field and you want to flag the records where the auto number is divisble by 10?

Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[abaldwin]

If so then look at this

My test table had two fields
name data type
myCounter autonumber
QcField text


UPDATE Table1 SET Table1.QCField = "QC NEEDED"
WHERE (([mycounter] Mod "10"="0"));

Assuming there were 31 rows in this table then row 10, 20, and 30 only get the text "QC NEEDED" in the qcfield.

Hope that is what you were looking for.

Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[jlnewbie]

Thank you, Andy that worked



JLopez
Lopez31@ATC-Enviro.com
Environmental Services @ Your Service

 

[abaldwin]

Your welcome.


Andy Baldwin

"Testing is the most overlooked programming language on the books!