N
Nelson
Hello,
I'm trying to get a query to capture data in a table that
will fall between two dates inputted by the user. The
date field in the table that I'm interested is in the
format of "short date (99/99/0000)", so in the query I
have the date field of the table, total is "where" and
the criteria I have "between inputbox([start
date],"Dates",,,) and inputbox([finish date],"Dates",,,).
When I try to run the query, it gives me the following
message: "This expression is typed incorrectly, or it is
too complex to be evaluated. For example, a numeric
expression may contain too many complicated elements.
Try simplifying the expression by assigning parts of the
expression to variables."
Please help, all I want is the user to be able to input
both a starting date and a finishing date to capture any
record between the dates.
Thank you,
Nelson
I'm trying to get a query to capture data in a table that
will fall between two dates inputted by the user. The
date field in the table that I'm interested is in the
format of "short date (99/99/0000)", so in the query I
have the date field of the table, total is "where" and
the criteria I have "between inputbox([start
date],"Dates",,,) and inputbox([finish date],"Dates",,,).
When I try to run the query, it gives me the following
message: "This expression is typed incorrectly, or it is
too complex to be evaluated. For example, a numeric
expression may contain too many complicated elements.
Try simplifying the expression by assigning parts of the
expression to variables."
Please help, all I want is the user to be able to input
both a starting date and a finishing date to capture any
record between the dates.
Thank you,
Nelson