By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,910 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Dates problem

P: n/a
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?

Feb 19 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
TB*****@gmail.com wrote in news:1171903037.176898.123580
@j27g2000cwj.googlegroups.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.
Feb 19 '07 #2

P: n/a
TB*****@gmail.com 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?

Feb 19 '07 #3

P: n/a
>
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.

Feb 19 '07 #4

P: n/a
On Mon, 19 Feb 2007 16:44:11 GMT, Lyle Fairfield <no@thanks.com>
wrote:
>TB*****@gmail.com wrote in news:1171903037.176898.123580
@j27g2000cwj.googlegroups.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.


Feb 19 '07 #5

P: n/a
"salad" <oi*@vinegar.comwrote
>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
Feb 20 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.