changes in query are ineffective

[chuck gregory]

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.

[missinglinq]

What have you (or your IT department) done to Access lately? What version and service pack are you running?

Linq ;0)>

[jaxjagfan]

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

[chuck gregory]

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.

Thanks.

chuck gregory