B
Brent Fanguy
Allen Browne and I are convinced this is a problem with
the way JET 4 handles of the Decimal field type.
Does anyone have a solution to the following problem:
1. Create a table with a Decimal field.
2. Enter a few rows: some positive, some negative, some
zero.
3. Create a query, sorting descending on the Decimal field.
Viewing the output of the query, you see:
- Negative values first.
- Positive values next.
- Zero values may be at the top (before the negatives) or
at the end (after the positives).
the way JET 4 handles of the Decimal field type.
Does anyone have a solution to the following problem:
1. Create a table with a Decimal field.
2. Enter a few rows: some positive, some negative, some
zero.
3. Create a query, sorting descending on the Decimal field.
Viewing the output of the query, you see:
- Negative values first.
- Positive values next.
- Zero values may be at the top (before the negatives) or
at the end (after the positives).