Senin, 28 Januari 2013

[MS_AccessPros] Cycling through records

 

I'm stuck on a problem that requires me to cycle through each record in a table looking for certain conditions in specific fields.  If I find one of these conditions I need to flag that record (I will probably just put a check in a Yes/No field called Flagged).

The part I cannot figure out is how to cycle through all of the records in a table until I run out of them.

Obviously it to be something like this:

Step 1 Start with the first record
Step 2 Look for the conditions and turn on Flagged when true
Step 3 Move to the next record
Step 4 Look for the conditions and turn on Flagged when true
Step 5 Repeat Steps 3 & 4 until there are no more records

It is Steps 1, 3 & 5 that are my problem.  Can you point me in the right direction; maybe a bit of sample code or a website where I might find out how to do this?

Thanks for any help you can provide.

[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar