What do you mean by count them but ignore one? If you count them, just
subtract 1 to ignore 1. Or is there more to it than that? Give some example
data and results.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"rosie36" wrote in message
...
I wish to count the number of different products using the database
function,
but need to exclude one of the products. Any ideas anyone?

Thanks

Rosie36