Hi

I have a query to return only last ten records added, made with wizard:

SELECT TOP 10 Tbl_Sponsors.SponsorID, Tbl_Sponsors.Title,
Tbl_Sponsors.FirstName, Tbl_Sponsors.LastName, Tbl_Sponsors.Ad1,
Tbl_Sponsors.Ad2, Tbl_Sponsors.Ad3, Tbl_Sponsors.Ad4, Tbl_Sponsors.Ad5,
Tbl_Sponsors.Ad6, Tbl_Sponsors.Email, Tbl_Sponsors.Rat,
Tbl_Sponsors.Postal, Tbl_Sponsors.[Welcome Email Sent],
Tbl_Sponsors.[Welcome Pack Sent], Tbl_Sponsors.[Date Joined],
Tbl_Sponsors.[Date Expire]
FROM Tbl_Sponsors
ORDER BY Tbl_Sponsors.[Date Expire] DESC;

Properties shows Top Values=10
Now for some reason, this worked fine before, but now it is returing 92
records, which is even weirder because there is 101 records in the db?
I can't figure out what it's excluding, as
there's no criteria. It is from the right table and getting the right
fields, just returning more than it should?

Any help would be appeciated, thank you!