[AccessD] Stored Procedure not producing results

If the structures haven't changed, then the data is the villain. But you have a concrete clue to work from. Devise some scope that will include only the data from two months ago and verify your assertion. Then expand the scope to "two months ago plus a day" and run it again. Repeat until failure.

This assumes of course that the scope is expandable so easily. (A good reason to have a "DateEntered" column in every table, which defaults to GetDate()). 

----- Original Message ----
From: David Emerson <newsgrps at dalyn.co.nz>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>; Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Tuesday, November 21, 2006 10:53:58 PM
Subject: Re: [AccessD] Stored Procedure not producing results

Worse - my database from two months ago works fine, but the latest 
version is the one that is causing the problem.  This may indicate a 
data problem perhaps?

David