Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
browndog
Starting Member
4 Posts |
 Posted - 2003-09-23 : 11:21:22
|
| I have a form based on my orders table which displays all of the orders for a given id. When the form is launched it is done by the docmd open form object. The records need to be sorted by the PK in asc order. The PK of the order table is defined as an int (sql server 2000). The orderby property is ignored by .adp files. Is there any way to specify a sort order when opening the form? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-23 : 16:18:24
|
| Ummm...create a view in SQL Server Order by pk?Or at the least make a query in Access an order by it?Brett8-)SELECT @@POST FROM Brain ORDER BY NewId()That's correct! It's an AlphaNumeric! |
 |
|
|
|
|
|
ordering records with .adp project