setting "date" criteria

When I set a criteria in a query "between [a] and [b]" to
prompt for dates "a" and "b" and then type in "8/16/04"
for "a" and "8/31/04" for "b" when prompted, I get
extraneous dates returned from dates prior to this range
from 2002 and 2003. I If I set the criteria as: "between
#8/16/04# and #8/30/04#" the dates are correctly displayed
(no extraneous data is displayed from 2002 and 2003). Any
ideas on how to get the correct dates displayed when
prompted by the query? The date field in the query is
the "general" date format.

thanks much
Jeff G

"Jeff G" wrote in message
...
When I set a criteria in a query "between [a] and [b]" to
prompt for dates "a" and "b" and then type in "8/16/04"
for "a" and "8/31/04" for "b" when prompted, I get
extraneous dates returned from dates prior to this range
from 2002 and 2003. I If I set the criteria as: "between
#8/16/04# and #8/30/04#" the dates are correctly displayed
(no extraneous data is displayed from 2002 and 2003). Any
ideas on how to get the correct dates displayed when
prompted by the query? The date field in the query is
the "general" date format.

Open the parameters dialog in the query's design view and explicitly set
the [a] and [b] parameters to Date DataTypes. Then try it again. Access
might be making an improper assumption about the DataType and doing a Text
comparison.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Bingo! thanks for your help
-----Original Message-----
"Jeff G" wrote in
message
...
When I set a criteria in a query "between [a] and [b]"
to
prompt for dates "a" and "b" and then type in "8/16/04"
for "a" and "8/31/04" for "b" when prompted, I get
extraneous dates returned from dates prior to this range
from 2002 and 2003. I If I set the criteria
as: "between
#8/16/04# and #8/30/04#" the dates are correctly
displayed
(no extraneous data is displayed from 2002 and 2003).
Any
ideas on how to get the correct dates displayed when
prompted by the query? The date field in the query is
the "general" date format.

Open the parameters dialog in the query's design view and
explicitly set
the [a] and [b] parameters to Date DataTypes. Then try
it again. Access
might be making an improper assumption about the DataType
and doing a Text
comparison.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.