Search results
-
B
Access ignores Order By in SQL Server queries
Ah... Thanks for telling me this. In hind sight, this makes perfect sense. Thanks for your time. Bruce- bruce_at_lmc
- Post #7
- Forum: SQL Server
-
B
Access ignores Order By in SQL Server queries
Yes, I use the TOP predicate. The query is below. SELECT TOP (100) PERCENT HairID, HairDescription, HairShort, DisplayOrder FROM bruce.Hair ORDER BY DisplayOrder- bruce_at_lmc
- Post #5
- Forum: SQL Server
-
B
Access ignores Order By in SQL Server queries
Hi, This makes no sense to me.... I have a SQL Server 9 (2008?) database in the cloud, and I've created an Access 2007 project (.adp). The connection works, I can see the tables and queries that I've created in SS, but when I double-click on a SS query in Access the data is correct but it...- bruce_at_lmc
- Thread
- Replies: 6
- Forum: SQL Server