I am trying to 'sort' an access database before outputting the contents. What is wrong with the following:<BR><BR>SQL = "SELECT * FROM strBook ORDER BY font_name"<BR>objRecordset.Execute(SQL)
What error(s) are you getting specifically? I think you might mean to run the Execute method of a connection object?
BTW, the SQL looks fine, assuming it is a valid table in your database and the column name you are sorting on is a column in the table that is not of type memo (or text)
You can't sort a column if that column is text?