Dates problem

[TBraddy@gmail.com]

I am modifying a ms access database query and am running into some
problems.

When I run a search for dates... it works up until 2/12/2007, but
after that it quits. I run another query that is similar, and it pulls
up information for that date range.

What could be going wrong?

[Lyle Fairfield]

Re: Dates problem

TBraddy@gmail.c om wrote in news:1171903037 .176898.123580
@j27g2000cwj.go oglegroups.com:

I am modifying a ms access database query and am running into some
problems.
>
When I run a search for dates... it works up until 2/12/2007, but
after that it quits. I run another query that is similar, and it pulls
up information for that date range.
>
What could be going wrong?

God decided to end the world on that date and, of course, Bill Gates knew.

[salad]

Re: Dates problem

TBraddy@gmail.c om wrote:

I am modifying a ms access database query and am running into some
problems.
>
When I run a search for dates... it works up until 2/12/2007, but
after that it quits. I run another query that is similar, and it pulls
up information for that date range.
>
What could be going wrong?
>

One query is correct and the other flawed?

Incorrect joins?

[storrboy]

Re: Dates problem

>
God decided to end the world on that date and, of course, Bill Gates knew.

There will be a patch released on Tuesday to fix that. It wasn't
supposed to happen until next year.

[Greg]

Re: Dates problem

On Mon, 19 Feb 2007 16:44:11 GMT, Lyle Fairfield <no@thanks.co m>
wrote:

>TBraddy@gmail. com wrote in news:1171903037 .176898.123580
>@j27g2000cwj.g ooglegroups.com :
>

>I am modifying a ms access database query and am running into some
>problems.
>>
>When I run a search for dates... it works up until 2/12/2007, but
>after that it quits. I run another query that is similar, and it pulls
>up information for that date range.
>>
>What could be going wrong?

>
>God decided to end the world on that date and, of course, Bill Gates knew.

It's the full-house effect.

2/12/2007

Seven digits: 3 2's and 2 zeroes. It's a full house. Beats two pair
all the time.

[Larry Linson]

Re: Dates problem

"salad" <oil@vinegar.co mwrote

>What could be going wrong?
>>

One query is correct and the other flawed?
>
Incorrect joins?

If Lyle is correct, this thread is all a figment of our ghostly
imaginations, in any case, and a futile discussion, perhaps.

But, if not, then there's great likelihood that salad's supposition is
accurate.

Of course, without knowing how TBraddy was "running a search for dates" and
details of what the Query's SQL statement contained and details of the
stored information being searched, we aren't likely to be able to figure it
out for certain, are we?

Larry Linson
Microsoft Access MVP