Count Dissimilar Things

[Novice1]

I have a form with an unbound field. I want the field to give me a number of dissimilar things. For example ...

Record 1: Cat
Record 2: Toy
Record 3: Cat
Record 4: Cat
Record 5: Desk

I want a count of 3 (Cat, Toy and Desk). Since the items change, I'm unsure how to approach this.

Any help would be appreciated.

 

[bob fitz]

Take a look at "crosstab" queries

 

[jdraw]

Try this SQL

SELECT Count(*) AS NumThings
FROM
(SELECT DISTINCT Name FROM YourTableName) ;