Bill,

You can use macro substitution. Try this:

m.lcOrder="Time"
SELECT * ;
  FROM mytable ;
  WHERE ... ;
  ORDER BY &lcOrder

>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,