CODEWITHSUNDEEP
ms-accessms-access-2010
AxxieD
AxxieD

Reputation: 614

Access 'No Records Found' when Records Exist

I have a form in Access 2010 that's used as a search form to filter records matching specific criteria.

I transferred information in the backend from one set of tables to another. Now, the filter doesn't work. Even if I leave all the criteria blank - ie. set it to bring up all records - it tells me, 'No records found.'

I've remapped the tables a few times, made sure they all have information, and are linking and opening properly. What could be preventing Access from finding the records?

Here's the filter query, if it helps any. It doesn't appear to be filtering properly, even though it works fine with the old tables.

    SELECT Activity.*, ActivityCash.*, EngSchDates.*, Monitoring.*, Procurement.*, 
    LookupDistrict.*
        FROM ((((Activity LEFT JOIN LookupDistrict ON Activity.District = 
LookupDistrict.District) INNER JOIN ActivityCash ON Activity.GWP = ActivityCash.GWP) 
INNER JOIN EngSchDates ON Activity.GWP = EngSchDates.GWP) 
INNER JOIN Procurement ON Activity.GWP = Procurement.GWP) INNER JOIN Monitoring ON 
Activity.GWP = Monitoring.GWP ORDER BY Activity.District, 
Activity.[ProgramYear], [Activity].GWP;

Upvotes: 1

Views: 182

Answers (2)

Beth
Beth

Reputation: 9607

In general, to debug these types of problems, try removing one table at a time from the FROM clause (and SELECT) until you get your results back.

Upvotes: 2

phicon
phicon

Reputation: 3617

Remove AND [Activity].[Designer] like '*' from the query.

Upvotes: 0

Related Questions