Query Question

[gtimmies]

Hi,

I would like to write query in Access 2013 to mark the first time a word appears as "Yes" and all subsequent times as "No". I have included a sample below. The bold column is what I would like the query to generate.

Thank you

#	Word	Distinct
1	First	Yes
2	First	No
3	Second	Yes
4	Third	Yes

[June7]

Cross-posted http://stackoverflow.com/questions/4...cate-in-access