I'm trying to write a query in an existing Access 97 database where I want to search on a date. The date has to be in a 1 week window about 6 months ago (it's for a report for printing which tests are required that week). The date is stored in a text field of size 20(I had nothing to do with it!).<br>
<br>
Any ideas?
<br>
Any ideas?