Don't count duplicates

[shenberry]

okay I set up a query that just gave me the max per teacher, but the max or not accurate, because it contains duplicates. If the same name appears I don't want the counter to increase.

So Count of Students: Count(*)
Expression

Yields 4 instead of 1
first name last name teaher
xyz bah teach


xyz bah teach
xyz bah teach
xyz bah teach

but atleast I access converted that data into a number. how can I convert a query to not pick up duplicates? So that teach will equal 1 instead of 4.

Thanks.

[ajetrumpet]

take a look at Allen Browne's function: http://allenbrowne.com/ser-66.html

it does just that.