|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 21st, 2004, 07:16 PM
|
|||
|
|||
Sorting using the OrderBy Property
Hi,
I have set the OrderBy with the following code: HiPlanNames.LastUpdated DESC That works well for just one field, but I need now to include another field (ST) wich should be sorted in ascending order; when I put it in after the above, it won't do it. HiPlanNames.LastUpdated DESC;HiPlanNames.ST Any suggestions or ideas, please ??? 
|
|
#2
September 21st, 2004, 08:47 PM
|
|||
|
|||
|
wrote:
Hi, I have set the OrderBy with the following code: HiPlanNames.LastUpdated DESC That works well for just one field, but I need now to include another field (ST) wich should be sorted in ascending order; when I put it in after the above, it won't do it. HiPlanNames.LastUpdated DESC;HiPlanNames.ST A semicolon indicates the end of an SQL statement, use a comma to separate the two fields. -- Marsh MVP [MS Access]
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Property sheet problem | Jim Orson | Using Forms | 4 | August 20th, 2004 04:13 PM |
| Can I use a variable in my OrderBy Property? | Bill Mitchell | Using Forms | 2 | August 17th, 2004 08:57 PM |
| Q2: KeepTogether property in Report Design View | Jeff Conrad | General Discussion | 3 | August 11th, 2004 07:35 AM |
| scrolling programmatically? | alekm | New Users | 1 | July 6th, 2004 02:56 AM |
| Formula Property - Referencing Strings Inside Formula Property Value | Oak | Worksheet Functions | 8 | February 10th, 2004 10:54 AM |
Linear Mode
