Recent content by jay123

Hi George, Couldn't see the wood for the trees! I think i was over complicating it in my head! Great idea, works like a charm! Thanks Jay

Yes, that option would be fine. I'm still puzzled how I would restart the count after a fail though.

Hi, it's more the 2nd option. but i need to show this: FieldA Result Count 101 Pass 1 101 Pass 2 101 Pass 3 101 Pass 4 101 Fail Then the count restarts 101 Pass 1 101 Pass 2 101 Pass 3 so i could then sumarise this to show the...

I'm sorry for appearing dim here. but can you explain a little more how i would achieve this. really appreciate your efforts on this.

I've tried this, but i cant think of a way to make the counter restart at zero after a 'fail' result. :confused:

Could you also use DCount? =DCount("Fieldname","QueryName","CriteriaField=something") so for example: =DCount("RecordID","OrdersT","CompanyName=ABC") this would count all records in the orders table for the company called ABC.

Hi All, Can anyone suggest any ideas for me regarding this topic. :confused: Basically, i have a timestamp field (containing date & time) and a result field (containing 'Pass' or 'Fail'). I need to count the number of consecutive 'Pass' results. As when an idividual consecutively passes 20...

Just to explain further. I need to show how many records people have passed in a row. when they hit 20, they are seen to be competant. However if they hit a fail, the process (or count) must start over again. you may be right, a loop statement may not make sense, so i'm open to any ideas...

Hi all, I'm new to access-programmers (and relatively new to access!!). I have an issue which i'm stuck on at the moment - and I cant seem to find a resolution! I would like to run a counter on records within a query which meet a certain criteria. And if record meets a different criteria, then...