Dates older than "X" (1 Viewer)

[Hacman]

I have a query in which I need to obtain all records older than "X". X can be any date. I have tried to write expressions but keep getting hung up on specifying the criteria to be less that X. For Ex. I have a [Date_Granted] and a [Search_Date] and I want to specify the [Search_Date] and then pull all records that are less than [Search_Date] pulling from [Date_Granted]. Any help??

 

[RichMorrison]

In the "Criteria" box in a query, you would enter
<=[Search_Date]

If the Search_Date is a field on a form, you will need to use
<=[Forms]![YourForm]![SearchDate]
where SearchDate is the name of a text box on form YourForm.

RichM

 

[Hacman]

This works well if a search date is already in place, but I need the query to prompt the user for a [Search_Date], then assign that date to all records and then give me less than for [Date_Granted]

 

[Hacman]

I am a nut, nevermind, I have it working, thanks for your help!