Hi Debra

97-2003 = 1000
2007 = 10000


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Debra" wrote in message ...
Does anyone know if there is a limit to how many values can be in the
dropdown in an autofilter? I have 67,000 plus records in my database with
that many different values. It is only showing me the first 10,000 values.