Sounds like some kind of security is filtering some of the records. Which file/form is the query pulling from? I assume that you, as the system analyst, have access to all data when querying, does the person who wrote the query have all access as well? If so, is there a way you can rule out security class issues?
|