Count() Until?

[schulzy175]

Is there any methods of counting records until a certain number is hit? I have my records counted just fine, but I want to limit the count to 3. So if a record has 6 counts, I want it to stop counting that record after it reaches 3 counts. Is this possible using query criteria? If not, how would VBA look to obtain this result? I have a good sum of experience with VBA, but I haven't messed with VBA much in regards to reformatting queries.

[June7]

Maybe you should select the TOP 3 for each group. Review http://allenbrowne.com/subquery-01.html#TopN

[schulzy175]

Ill check that out, thanks. In the meantime, I used a (maybe not recommended) workaround. I created another query using an IIF statement telling to set the record to 3 if the count is < 3.