Date Range

[jstringer]

I need to search through a date field in a record set and create a new temporary table containing all records that are more than 3 months old. Is there anyway I can do this using SQL?

Thanks

John

 

[KenReay]

hi

Yes, no problem first use the query builder to make a select query which selects are rows with Date < DateAdd(&quot;m&quot;,-3,Date()), then use the meu option to convert this into an append query Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK