Date Range in Query

[gheyman]

I have two unbound text boxes on a form that I want to use the date range from in my query.

Here is the bad formula I used in the Crtieria: >=#[Forms]![frmPIDLibrary]![Text15]# And <=#[Forms]![frmPIDLibrary]![Text17]#

Help please

 

[Chrisdontm]

I believe that what you need is called TEMP VARS.
It will have to be declared in the criteria of the query.

I believe it means a "temporary variable"....

 

[james_lankford]

try getting rid of the #

 

[gheyman]

try getting rid of the #

Thanks