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 <[email protected]> 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: [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 > -- 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
