Unique values

[helpaccess]

I have two queries. One return the most recent date and test score. The other returns the next most recent date and test score. I want to make sure there is only one score per student in each query, but right now, it is showing multiple scores for some students. I have checked the Unique values property box to yes, but that isn't working. Any other ideas?

[June7]

We need sample data and/or query statements to analyse.

[helpaccess]

SELECT Max([SATS-R LOCUS].[Date Completed]) AS [SecondMaxOfDate Completed], [SATS-R LOCUS].Client, [SATS-R LOCUS].[Level Of Care] FROM [SATS-R LOCUS] INNER JOIN MaxDateLOCUS ON [SATS-R LOCUS].Client=MaxDateLOCUS.Client WHERE ((([SATS-R LOCUS].[Date Completed])<(MaxDateLOCUS.[MaxOfDate Completed])) And (([SATS-R LOCUS].Client)=MaxDateLOCUS.Client))
GROUP BY [SATS-R LOCUS].Client, [SATS-R LOCUS].[Level Of Care] ORDER BY Max([SATS-R LOCUS].[Date Completed]) DESC;

[June7]

I think what you need to do is return the Top 1 record in each group where [Date Completed] is less than the Max([Date Completed]). This might not be an easy query to understand and build. I would need data to build and test with.

Google: sql top 1 for each group