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.