Can you show us the SELECT Statement?

You may want to go to http://utteraccess.com , http://mvps.org/access , or http://candace-tripp.com for some great examples using dates.

Kent
_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's