I have a form which when run allows the user to pick the order for which the report is printed. This is in a combo box that allows the user to pick the order 'time' or 'phone no'. Is there any way to put the variable in an ORDER BY statement of an SQL-SELECT or do I have to write two conditional SQL statements?
TIA,
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!