Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index


Thank you to everyone who replied to my query, A01, A02 etc works, I am
very thankful for that. Now the problem to prevent duplication, I have
tried several ways but obviously what I am doing is incorrect as it doesn't
work.
Could someone please do a very small database to show how this problem can
be overcome.

Many thanks in anticipation.
John


On 3 March 2016 at 11:54, Alexander Thurgood <alex.thurgood@gmail.com>
wrote:

Le 02/03/2016 20:07, John Montgomery a écrit :

Hi,


My problem arises when I enter double numbers eg A11, A20 etc, these
should
follow in sequence but do not follow the sequence I want but A10 follows
A1
etc.
How can I ensure correct sequencing.

As others have mentioned, you could try using a double, triple,
quadruple, etc, digit numbering sequence from the start. If your
cemetery has 4000 graves in row A, then enter A0001, A0002, etc.

Alternatively, create a separate table for your row/number
identification, with a unique ID value for each pair, concatenate the
result in your form, but sort them via the unique ID value.

Alex



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.