2. ASPRunnerPro General questions
  3. Ordered Output
This topic is locked

Ordered Output

 		2/24/2006 8:46:42 AM
ASPRunnerPro General questions
TheCapt author

I am trying to run a report from my database which gives me an ascending ordered output.
The two fields I am trying to order are HouseNo and Streetname and I would like the list to be in order of house number first then street name after e.g.
2 BOUGHTON LANE

3 BOUGHTON LANE

4 BOUGHTON LANE

6 BOUGHTON LANE

41 SHERNOLDS

43 SHERNOLDS

45 SHERNOLDS

47 SHERNOLDS

51 SHERNOLDS
When I click on this menu item the records are shown as they are put into these database from add record.

i.e.
3 BROADFIELD ROAD

73 RICHMOND WAY

83 BOUGHTON LANE

23 RICHMOND WAY

519 LOOSE ROAD

503 LOOSE ROAD
If I click street name at the top of the table the streets are put in order but the numbers are not
Can you please let me know how I can get all the records to sort in ascending order as per the first list
Thanks
Peter
Sergey Kornilov admin 2/24/2006

Peter,
to set initial records ordering click Order By - Change.. on the Edit SQL query Tab.
TheCapt author 2/25/2006

I have already done this.
I have two ordered items
First

Houseno - ASC

and then

Streetname - ASC
However the rocords still show as previously described
Regards
Peter
Sergey Kornilov admin 2/26/2006

Peter,
Order ...button defines initial sort order only. After you click on any table column header data will be sorted by this single column.
O
 		osluk 5/5/2007

Peter,

Order ...button defines initial sort order only. After you click on any table column header data will be sorted by this single column.


Is there a way to add the sort criteria into the search string?
Chris