ICTkirsten
Registered User.
- Local time
- Today, 09:10
- Joined
- Jan 3, 2015
- Messages
- 137
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
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
