Date Prompt to display records Less than a date

[Access nubie]

When a query is run, i want a prompt displayed allowing the user to enter
< DATE to find all records less than the specific date. e.g. < 1/1/2011.

I know how to do that with a start date AND end date (Between [Enter Beginning Date] And [Enter End Date]), but that's not what I'm looking for.

The records will be updated by small number of users with a Last Reviewed date every 2 months. i'll just want to check for records that have not been updated in the last 3 weeks or so of running the query. ​

 

[themurph2000]

When a query is run, i want a prompt displayed allowing the user to enter
< DATE to find all records less than the specific date. e.g. < 1/1/2011.

I know how to do that with a start date AND end date (Between [Enter Beginning Date] And [Enter End Date]), but that's not what I'm looking for.

The records will be updated by small number of users with a Last Reviewed date every 2 months. i'll just want to check for records that have not been updated in the last 3 weeks or so of running the query. ​

Does the query have to give the user the option of putting in a < or >? If not, simply give one option for the date. [Enter Date] would work as a parameter query.

As for updating, you can have Access record the date a record was altered and you can do your query on that. Here's the site at Microsoft.

http://office.microsoft.com/en-us/access-help/recording-the-date-and-time-when-a-record-is-modified-in-access-HA001034535.aspx

 

[Access nubie]

yes, i need to display all records where the date is less than the date entered by the user. I would have liked to have been able to put the greater than/less than symbol in the prompt. if that's not possible, some advised to put the symbol in the query itself as follows:

<[Enter desired date]

That would be next best solution....

 

[themurph2000]

yes, i need to display all records where the date is less than the date entered by the user. I would have liked to have been able to put the greater than/less than symbol in the prompt. if that's not possible, some advised to put the symbol in the query itself as follows:

<[Enter desired date]

That would be next best solution....

Here's an odd solution. And it's not fullproof, but you can try it. Use two parameter queries.

< [Enter a Date for OLDER records]
OR
> [Enter a Date for NEWER records]

This, of course, will rely on people only entering one or the other, but not both, but you can use the OR line of the Query grid to set this up.