FamiliaFrazelle wrote:
i'm making a report, based on a query. The report is Grouped and
Sorted, first on Date, then Neighborhood, then Street. In the detail
area, the first control is the house number which, when the report is
generated, does not order the house number in ascending order. i've
ordered the field in the query and even in the table, but the report
continues to present the house numbers in a jumbled order. Is there any
way to get the report to order the house numbers in ascending order?
Have a great evening! :)
Hi
Ithink you will find that if you want to sort on the house number you
will need to put the number in a separate field from the address and set
it up as a number. Otherwise the sort will be in alphabetic order and
not numeric so it will be something like 1, 11, 111, 112, 113, 12, 13,
14, 15, 16, 17, 18, 19 etc.
I hope that helps.
Rob
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org