Sort order in DBW

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

Hi
I use FP 2003 the DBW to create a recordlist from an accessdb. I want the
sort the list from the value i a dayfield. The dayfield contains the values
1 or 2 or 3 ............31.
When I try to sort it with the DBW I get the values in sort order 1,
10,11..........2,21 an so on.
Is there anyone that could give me some help
I appreciate any answer
Ted
 
01, 02, 03, 04...?



| Hi
| I use FP 2003 the DBW to create a recordlist from an accessdb. I want the
| sort the list from the value i a dayfield. The dayfield contains the values
| 1 or 2 or 3 ............31.
| When I try to sort it with the DBW I get the values in sort order 1,
| 10,11..........2,21 an so on.
| Is there anyone that could give me some help
| I appreciate any answer
| Ted
|
|
 
Thanks Rob
Ok that solves the problem but is that the only way to do it. I want to list
the result without 0 just 1, 2 ........
Ted
"Rob Giordano (aka: Crash Gordon®)" <[email protected]>
skrev i meddelandet 01, 02, 03, 04...?



| Hi
| I use FP 2003 the DBW to create a recordlist from an accessdb. I want the
| sort the list from the value i a dayfield. The dayfield contains the
values
| 1 or 2 or 3 ............31.
| When I try to sort it with the DBW I get the values in sort order 1,
| 10,11..........2,21 an so on.
| Is there anyone that could give me some help
| I appreciate any answer
| Ted
|
|
 
Dunno, I'm not a db guru, my suggestion was just a logical guess :-)


| Thanks Rob
| Ok that solves the problem but is that the only way to do it. I want to list
| the result without 0 just 1, 2 ........
| Ted
| "Rob Giordano (aka: Crash Gordon®)" <[email protected]>
| skrev i meddelandet | 01, 02, 03, 04...?
|
|
|
| | | Hi
| | I use FP 2003 the DBW to create a recordlist from an accessdb. I want the
| | sort the list from the value i a dayfield. The dayfield contains the
| values
| | 1 or 2 or 3 ............31.
| | When I try to sort it with the DBW I get the values in sort order 1,
| | 10,11..........2,21 an so on.
| | Is there anyone that could give me some help
| | I appreciate any answer
| | Ted
| |
| |
|
|
 
Back
Top