<BR>All records which are in the table(Access database) for more than 30 days should be deleted. <BR>How can this be done? <BR><BR>Get day, month and year which was on 30 the day from today and then delete <BR>it? I'm not sure which date function should I use? <BR><BR><BR>startdate = date() <BR>sqld = "SELECT * from events WHERE datevalue(evdate) < " & startdate <BR><BR><BR>This does not pull up any records.. obviously my SQL is missing something. <BR><BR>I'll greatly appreciate any help.