Select Top issue

Hello ive used this sql for my query to allow me to view the medication history of my customers but for the last 10 records only..

the only issue is it only shows about 5 records and some are blank i have 5 other records in2014 but only 2015 appear





SELECT TOP 10 Medication.CustomerID, Medication.[mild], Prescriptions.[weak ], medication.[Date]

FROM Medication

WHERE (((Medication.CustomerID)=[Forms]![FrmAppointments]![CustomerID]))

ORDER BY Medication.[Date] DESC;



can someone help me :(

Select Top issue