weird query issue

R

Ray

I have a single table that contains customer information
with 5 queries that I'm trying to run. These queries are
of a range type where I'm filtering on a particular date
range. Four of the queries work fine. However, one query
refuses to return correct information. When i put in my
date ranges, the query returns only a portion of the
accounts and in addition reports other accounts that are
beyond the date range. The command that I'm using is
"between[Type Beginning Date:]And[Type Ending Date:]".
I've looked at the data field in an attempt to determine
the cause but without success. Any suggestions would be
greatly appreciated.

Thanx in advance
 
D

Dale Fye

Ray,

Have you defined the input types as dates? If not, Access may be
interpreting them as strings, and the conditions you describe makes it
sound like it is interpreting the dates as strings.

Go to your query in design view, place the cursor in the grey area
next to where the tables are displayed. Right click and select
Parameters, then in the boxes provided enter your parameter names
(include the braces - [Type Beginning Date:], and make sure the text
is exactly as it is in your query.

--
HTH

Dale Fye


I have a single table that contains customer information
with 5 queries that I'm trying to run. These queries are
of a range type where I'm filtering on a particular date
range. Four of the queries work fine. However, one query
refuses to return correct information. When i put in my
date ranges, the query returns only a portion of the
accounts and in addition reports other accounts that are
beyond the date range. The command that I'm using is
"between[Type Beginning Date:]And[Type Ending Date:]".
I've looked at the data field in an attempt to determine
the cause but without success. Any suggestions would be
greatly appreciated.

Thanx in advance
 
Top