Since I am using Access 2000 I am unable to use the SQL statement some of you suggested. <BR><BR>So I tried this. the variable "idate" is the date value that is stored in my database. Shouldn't this be working? <BR><BR>"WHERE idate BETWEEN Date() AND Date() - 30 "