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 [Forms]![frmClasses]!lstReportCriteria_Attended]
CASE "Name"
Name ASC
CASE "Date"
Date ASC
END SELECT
Thank you in advance for your help!!!
SELECT Name, Date
FROM tblTemp
ORDER BY
SELECT CASE [Forms]![frmClasses]!lstReportCriteria_Attended]
CASE "Name"
Name ASC
CASE "Date"
Date ASC
END SELECT
Thank you in advance for your help!!!