How to display count values

[stefaniejo]

I'm trying to count the number of occurrences of a specific field, but I have some instances when the primary indicator is duplicated. For the first occurence I want to show a 1 and for everything else I want to show 0. I am sorting by the field so that all occurences are together. Is this possible?

In Excel I use a formula =IF(F2=F1,0,1), but I'd like to get away from using formulas in Excel and just shoot this out of Access.

 

[lemo]

not sure how to do this exactly, but i just got an answer to my question, which i think could be helpful for your task.
see here - http://www.access-programmers.co.uk/forums/showthread.php?t=208834
good luck,
l

 

[stefaniejo]

I'll give it a whirl and see if it works...