If it was working before, I would start by looking at the data.
the recordset being used has a couple of INNER JOIN statements.
using an INNER JOIN means that a result will only be returned if there is data in both tables to satisfy the join criteria.
for example, the first inner fjoin:
FROM dbo.tblApplicationScores INNER JOIN
dbo.tblScoringGroups ON dbo.tblApplicationScores.scoringGroupID = dbo.tblScoringGroups.scoringGroup
if there is not a record where:
dbo.tblApplicationScores.scoringGroupID = dbo.tblScoringGroups.scoringGroup
no result will be returned.
try changing the join types to see if that effects the results using LEFT, RIGHT or OUTER joins.
