BleepingComputer.com: Access Query Help

Hi, Just trying to make a database in Access that'll allow the user to run a query and find out all records that are 10 years or older i.e. a piece of equipment that was last serviced in May 1997 requires servicing and once that was done in november 2005 doesn't. Also, is it possible to write a line into another query that will bring up items that are nearing the replacement date? Sorry if this is simple, but i've lost track of access and forgotten it since I left college!

Dan

In the query design view, select the fields you want to see.
Under the first four lines are rows for multiple selection criteria.
Just as a quick way to get you started,

under a date you can enter things such as ">=Now()-7" to get records for the last week.
"<=Now()-364.25*2" will return records roughly over 2 years old or if you're fancy, ask the user to enter the date using 'parameters' (I'd give it to you, but am running out of time

Don't use quotes.
Date functions can be tricky, but if you double click the entries, Access helps with syntax.
You can combine (AND) one criterion with another by writing them one above another.
And if I recall, OR needs to go across, so may have to pull the field names twice.

See Help for 'parameters' and 'selection criteria' and examples Access offers.