Report grouping and counts

[siobhanh]

Is there a way to count only unique values as opposed to all occurences of a value? in other words if i have 5 records with 3 with xyz and 2 with gbh then i would like to get 2 for 2 values as opposed to 5.
Thank you.

[HiTechCoach]

Thee are a few ways to do this depending on your needs.

See:
ALL, DISTINCT, DISTINCTROW, TOP Predicates (http://office.microsoft.com/en-us/access-help/all-distinct-distinctrow-top-predicates-HA001231351.aspx)