Posted by Jer on 01/31/07 23:44

I am using Access 2003 as a front-end to a SQL Server 2005 database.
I make design changes using SQL Server Management Studio. I have a
table that includes a datetime column. I create a view and sort by
the datetime field. When I initially look at the result it is sorted
correctly. Then I save the view and re-open it and it is not sorted.
I've simplified the view so it only contains the date field and it
still does not sort. Here is the view:
SELECT TOP (100) PERCENT Period_Date
FROM dbo.Period_Summary
ORDER BY Period_Date DESC

The date seems to be a random order.
I don't have this problem in the SQL Server 2000 version of the
database.

Help please!
Thanks,
Jerry

[Back to original message]