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.