Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Sorting
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...- aharmon
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Queries & Forms
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...- aharmon
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
