I have a boolean field in my access database. I am trying to create a function that returns true when that boolean field = true. There are multiple records though. So I would need something that does this (in vb6 pseudocode)

Assume that all records will be true (set the flag to true)
For each record (until EOF=true):
Does the field = false?
If so, then set the flag to false
Go to the next record and test again

Anyone have any ideas? I think I might be able to do something like this with a running total field. I don't need to enter to code as I jsut showed, but I just put it there for conceptual purposes.