Date Selection Question

  • Thread starter Thread starter Dean Turner
  • Start date Start date
D

Dean Turner

I have a query which I am adding a Where clause using the
Between instruction.

When I enter Between #12/29/2002# AND #3/22/2003# I get
95 records which is correct.

When I enter Between #3/23/2003# AND #6/14/2003# I get 69
records which is also correct.

When I enter Between #12/29/2002# AND #6/14/2003# I get
100 record which is clearly wrong. I should get 164
records.

Does anyone have any Ideas?

Thanks Dean
 
Dean said:
I have a query which I am adding a Where clause using the
Between instruction.

When I enter Between #12/29/2002# AND #3/22/2003# I get
95 records which is correct.

When I enter Between #3/23/2003# AND #6/14/2003# I get 69
records which is also correct.

When I enter Between #12/29/2002# AND #6/14/2003# I get
100 record which is clearly wrong. I should get 164
records.

Does anyone have any Ideas?

Thanks Dean
Click to expand...
Does the query say DISTINCT, maybe? (unique values)
 
I have a query which I am adding a Where clause using the
Between instruction.

When I enter Between #12/29/2002# AND #3/22/2003# I get
95 records which is correct.

When I enter Between #3/23/2003# AND #6/14/2003# I get 69
records which is also correct.

When I enter Between #12/29/2002# AND #6/14/2003# I get
100 record which is clearly wrong. I should get 164
records.

Does anyone have any Ideas?

Thanks Dean
Click to expand...

Is there any other criteria being used?
What characteristics do the missing records have in common?
Are they all at the end of the period? All at the beginning?
Examine the missing record dates and perhaps they will indicate the
problem.
 
Back
Top