Eljefegeneo
Still trying to learn
- Local time
- Today, 09:07
- Joined
- Jan 10, 2011
- Messages
- 902
Getting a little crazy on this. I have a select query as follows:
I cannot get the list to sort ascending.
I even tried to use the above to make a new query, and select Ascending rode, but the results are the same. My understanding that if you use Distinct it automatically sorts Ascending.
Code:
SELECT Distinct tblPrescriptions.Medicine
FROM tblPrescriptions
WHERE (((tblPrescriptions.ForWhom) Like "*M*") AND ((tblPrescriptions.DatePurchased) Between Date() And Date()-365))
ORDER BY tblPrescriptions.Medicine;
I even tried to use the above to make a new query, and select Ascending rode, but the results are the same. My understanding that if you use Distinct it automatically sorts Ascending.