Passing >Date() from form to query causing probs

[cashe]

Hi all,

I think I'm missing something simple but don't know what it is

I have a Search Form which has 3 check boxes on it. when a check box = True it passes a criteria to a text box. The text box then passes the criteria to a query.

Check box Check_Mob passes >=Date() to [Criteria13] and Check_Demob passes <Date() to [Criteria13]. In the Demobilised field of the query I have [Forms]![frmPowerSearch]![Criteria13] set in the criteria row. However this does not work.

I have tried setting the query parameters to [Forms]![frmPowerSearch]![Criteria13] DateTime but still no luck

I have 12 other text boxes that are parameters for the query. These all work great. Any ideas why it does not work when <Date() or >=Date() are passed through.

Thanks in advance

Cashe ;-)

 

[JeremyNYC]

Cashe,

It's hard to tell what exactly is being passed without seeing the code that builds the sql, or the sql from the query, but you have to offset dates with # in sql. If you're doing this is code you'll have to include those. If you're doing it via a parameter query I would guess that you would want the text box to hold the actually date, not the function call, as it's going to get passed as a literal, I would think.

Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.