Parameter problem

[Guest]

I am trying to use a parameter for specifying a date range; "between [enter start date] and [enter end date]", the field in the table has a format of "mm/dd/yy", "hh:nn" and a input mask of "00/00/00\ 00:00;0;_". I have gone into the properties for this feild reference in the query and set the format and input mask to match. When I run the query and put the start date, 03/19/04, 00:00 in first prompt and 03/19/04, 12:30 in the second prompt I get the following error: "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numberic expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.
I have also tried putting this in place, [#enter start date#] and get the same error.

 

[Van T. Dinh]

Try:

03/19/04 00:00
03/19/04 12:30

instead.

--
HTH
Van T. Dinh
MVP (Access)

I am trying to use a parameter for specifying a date range; "between

[enter start date] and [enter end date]", the field in the table has a
format of "mm/dd/yy", "hh:nn" and a input mask of "00/00/00\ 00:00;0;_". I
have gone into the properties for this feild reference in the query and set
the format and input mask to match. When I run the query and put the start
date, 03/19/04, 00:00 in first prompt and 03/19/04, 12:30 in the second
prompt I get the following error: "This expression is typed incorrectly, or
it is too complex to be evaluated. For example, a numberic expression may
contain too many complicated elements. Try simplifying the expression by
assigning parts of the expression to variables."

I have also tried putting this in place, [#enter start date#] and get the

same error.

 

[fredg]

I am trying to use a parameter for specifying a date range;
"between [enter start date] and [enter end date]", the field in the
table has a format of "mm/dd/yy", "hh:nn" and a input mask of
"00/00/00\ 00:00;0;_". I have gone into the properties for this
feild reference in the query and set the format and input mask to
match. When I run the query and put the start date, 03/19/04,
00:00 in first prompt and 03/19/04, 12:30 in the second prompt I
get the following error: "This expression is typed incorrectly, or
it is too complex to be evaluated. For example, a numberic
expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to
variables." I have also tried putting this in place, [#enter start
date#] and get the same error.

The comma is not part of the field.
Get rid of the comma in the date/time entry:
03/19/04 00:00
03/19/04 12:30