Creating labels one per person

[Guest]

I have a query that i have created. A person may be listed on there multiple
times, but I want to create labels that displays one per person. How do I do
that? In my query each person is identified with an unique person number.

thanks,
Karen

 

[Joseph Meehan]

I have a query that i have created. A person may be listed on there
multiple times, but I want to create labels that displays one per
person. How do I do that? In my query each person is identified with
an unique person number.

thanks,
Karen

I suggest you use the DISTINCT statement.

 

[Guest]

I'm not exactly sure on how to do that. I tried to do it in SQL view in my
query but it didn't work. Maybe I had it in the wrong place. I'm fairly new
at working with access

 

[Guest]

Open up you query in query design and click on the Total button (looks a bit
like an E - sigma sign)

This generates the disctinct keyword for you.

 

[Guest]

Thanks! That worked..

Open up you query in query design and click on the Total button (looks a bit
like an E - sigma sign)

This generates the disctinct keyword for you.