|
| |
|
|
FPGuy
Posts: 13
From: None
Status: offline
 |
Sorting on a currency field? - 3/1/2001 17:16:00
I followed the instructions to sort on different field via microsoft's link in spooky's advanced section. Things work great except I want to be able to sort by price and when I do the results are sorted like this
$1.32
$1.45
$15.23
$1.62 etc. Anyways it appears to ignore the decimal. Anyone know whats up? [This message has been edited by FPGuy (edited 03-01-2001).]
|
|
|
|
FPGuy
Posts: 13
From: None
Status: offline
|
RE: Sorting on a currency field? - 3/2/2001 20:15:00
Figured it out, I was sorting on a field that I was formatting in the query so it wouldn't truncate the price ie. $6.5 instead of $6.50. When I sort on the actual price field it works fine.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
