Ian,
Is there an id key field? If there is the default sorting is by the id key
(usually numerical order).
In SQL you can add the line:
ORDER BY Last-Name, First-Name
The default order is ascending (ASC) if descending is needed
ORDER BY Last-Name DESC, First-Name DESC
On Mon, 26 Aug 2013 08:00:24 -0400, Ian Whitfield <[email protected]>
wrote:
Hi All
I now have my new MySQL/LO Base Database up, running and fully edited
from the old one. And what a pleasure it is to work with!! This IS the
way to go,
One question - It seems to have a strange way of sorting the Data as
displayed in the Form I designed and I have to select 'Sort' in the
bottom Bar and then pick 'Last Name', Ascending and 'First Name'
Ascending to get it the way I want it.
Unfortunately it does not seem to keep this Sort!! Is there a way to
"lock' this sort or to make it automatically do it when you start the
program??
PClinuxOS 2013
LO Version 3.6.5.2 (Build ID: 5b93205)
Thanks for any help.
IanW
Pretoria RSA
--
Jay Lozier
[email protected]
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
