Has anyone got any ideas? My minds gone blank. I have a search tool, where they can click records added in last 2 weeks. The record in the table is: Pdate Was thinking about using the DateDiff function to work out if the date is within 14 days. But im not havign much luck. The database is Access. So any ideas? Cheers Skuff