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

changes in query are ineffective

P: 78
I have a query that filters by date. Previously it worked quite well.

Today when I opened it, I found about 30 percent of the forms controlled by the query had dates well outside the parameters set by the query.

The query filters to exclude any date earlier than 9/30/2007 and to permit a null in that field.

Trying to change either of those two today either nas no effect or allows an additional 500-plus records to be shown. I have not modified the form in the recent past. Any help would be appreciated.
Dec 27 '07 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 3,532
What have you (or your IT department) done to Access lately? What version and service pack are you running?

Linq ;0)>
Dec 27 '07 #2

Expert 100+
P: 254
Is this data populated from another source into your database? I.E. another database, text imports, etc whereas the data may be corrupted or changed somehow.

Open the query in design view. Go to View ...SQL View. Hightlight the SQL, copy and paste (or a close facsimile) for us to take a look at.

Does your criteria for your date field look like or equate to the following: >#9/30/2007# OR NULL
Dec 27 '07 #3

P: 78
It's Access 2002 (10.6501.6830). The data has always been only in this database, and the filter in the query is as you stated, >9/30/2007# Or Is Null.

And the problem seems to have fixed itself while you were writing your replies! Up until about 11:30, it was still a problem.

I guess the threat of calling the repairman worked again.


chuck gregory
Dec 27 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.