I have a querie that includes name and date. The user chooses how they want to sort their report (either by name or date) on a form by selecting an option in the listbox. Here's what I want to do, but am not sure how to do it:
SELECT Name, Date
FROM tblTemp
ORDER BY
SELECT CASE...
Hi. I hope you can help me. I have an access table which keeps up with students and what classes they have attended and another on that has all the classes offered.
Here is an example:
tblStudents
Student_ID FirstName LastName ClassesToSearch
1 John Smith 1,4,6
5 Wendy...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.