Help with parameters

[Guest]

I have set up a parameter in a query that will look between a beginning and
ending date. When I try to run it from a report, I get the following error.
This expression is typed incorrectly. For Example, a numeric expression may
contain too many complicated elements. Try simplifying the expression by
assigning parts of the expression to variables. I set the field to short date
"6/1/07" and I get this error. Not sure what to do, any ideas. Thanks in
advance.

 

[Guest]

Can you post the SQL?
But before try using CVDate to convert the paramter to date

Select * From TableName
Where DateFieldNAme Between CVDate([Please select start date]) And
CVDate([Please select end date])

 

[Guest]

Or, mybe better using CDate

Select * From TableName
Where DateFieldNAme Between CDate([Please select start date]) And
CDate([Please select end date])

--
Good Luck
BS"D

Can you post the SQL?
But before try using CVDate to convert the paramter to date

Select * From TableName
Where DateFieldNAme Between CVDate([Please select start date]) And
CVDate([Please select end date])
--
Good Luck
BS"D

I have set up a parameter in a query that will look between a beginning and
ending date. When I try to run it from a report, I get the following error.
This expression is typed incorrectly. For Example, a numeric expression may
contain too many complicated elements. Try simplifying the expression by
assigning parts of the expression to variables. I set the field to short date
"6/1/07" and I get this error. Not sure what to do, any ideas. Thanks in
advance.