On Thu, 24 Jul 2008 17:13:00 -0700, PatK
wrote:

I am getting a sql error on the execute, stating there is an error "near
DESCENDING". I cannot see what that would be. The output of the debug of
strSQL is:

SELECT Planned_Obs_Date, Actual_Obs_Date, PlannedRetFYQtr, IT_Owner_L2,
IT_Owner_L3, IT_Owner_L4, date_of_last_record_update FROM
dbo.hpsc_application WHERE IT_Owner_L2 = 'my owner name field (data)' ORDER
BY Actual_Obs_Date DESCENDING


I believe the proper syntax is:

ORDER BY Actual_Obs_Date DESC;
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com