I'm not getting the results I expect in a report. It looks like some records are missing.

The first thing to check is that you have the correct filter for the report. If the filter is too restrictive, you won't see all the records you expect. The second thing to check is that Stonefield Query is accessing the correct database. Finally, if your database has a "reindex" or "database maintenance" feature, use that feature to ensure the database indexes are accurate.