I dunno, that's not working for me, at least in Access 2000. That appears to be retrieving all the records (appears to, because the query runs awfully slowly). There's almost 16K records in the table, but I wouldn't expect more than a few hundred records to be returned at most. 90 questions x 10 modules, but not all modules ask all questions.
It might be easier to do this in code, but the co-worker doesn't understand code & wants the query, also preferably with the client name (from another table) matching the client code, which both tables have.