query where field

  • Thread starter Thread starter Nelson
  • Start date Start date
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
 
Why use the input box function at all?

Between [Enter the Start Date] and [Enter the End Date]

should work.
 
Back
Top