"Between date" query

I have a query that I use to return transactions that happened between a
specific set of dates, and the person responsible for those transactions. It
worked fine for a few months, but now returns odd results. For example, if I
select a date range of 09/01/05 to 09/30/05, it also returns records from
03/05, 05/05, 06/05, and 10/05. I've gone through post after post with no
answer. Can someone point me in the right direction?

The dates you have provided are between the dates you are querying?

John


"C_F" u16690@uwe wrote in message news:58e0073638d66@uwe...
I have a query that I use to return transactions that happened between a
specific set of dates, and the person responsible for those transactions.
It
worked fine for a few months, but now returns odd results. For example, if
I
select a date range of 09/01/05 to 09/30/05, it also returns records from
03/05, 05/05, 06/05, and 10/05. I've gone through post after post with no
answer. Can someone point me in the right direction?

Hi,


Do you use a date_time field or a string, as data type, to hold the date
data?

Are the date all in US format, dd-mm-yyyy, or are some also in the format
mm-dd-yyy, or worse, are there some with only two "numbers", like dd-mm
( or mm-dd) ? Is that a possible pattern for the records "in error" ?


Hoping it may help,
Vanderghast, Access MVP


"C_F" u16690@uwe wrote in message news:58e0073638d66@uwe...
I have a query that I use to return transactions that happened between a
specific set of dates, and the person responsible for those transactions.
It
worked fine for a few months, but now returns odd results. For example, if
I
select a date range of 09/01/05 to 09/30/05, it also returns records from
03/05, 05/05, 06/05, and 10/05. I've gone through post after post with no
answer. Can someone point me in the right direction?