Date Criteria from Text Boxes

[MikeAngelastro]

Hi,

I'm trying to run a query where a date is between two dates that are contained in text boxes on a form. Access keeps telling me that the expression is too complex. I used a CDate function in the query but it doesn't change the results. Anyone know how I can handle date criteria in a query when the dates are in text boxes on a form?

Thanks,

Mike

 

[pdx_man]

I do it all the time. You're problem isn't the text boxes. Are you using other aggregate functions? Post your SQL.

 

[MikeAngelastro]

Do you mean that I can't use any aggregate functions if I reference a text box for criteria?

 

[pdx_man]

Yes you can, what I am saying is that it is probably in the syntax of your aggregate function. Something like:

Dlokup("MyField","MyTable",MyCriteria)

Or something else. If you post your SQL, that would help me help you. View, SQL View from the design view of your query. Copy and paste here.