problems with query

D

Dan

I have a query that that when you open it, or a form with this query as a
record source, and scroll down quickly; it tries to bring up a record that is
larger than the number of records that their is. It immediately errors out
and has to repair the database. The query is:

SELECT ...
FROM [members info]
WHERE ((([members info].[id]) Not In (SELECT [id] FROM [orders] WHERE
Month([DateMatched]) & "/" & Year([DateMatched]) = Month(Date()) & "/" &
Year(Date())) And ([members info].[id]) Not In (SELECT [id] FROM [Matches]
WHERE Month([DateMatched]) & "/" & Year([DateMatched])=Month(Date()) & "/" &
Year(Date()))) AND (([members info].Status)="active" Or ([members
info].Status)="AR - In Matching"));
 
Top