Re: [libreoffice-users] Re: Database help please
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.thurg...@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+unsubscr...@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+unsubscr...@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
[libreoffice-users] Database help please
Dear Sirs, I am trying to assemble a simple graveyard database but am having difficulty in getting the form to work as I want. I have tried to use parts of the "Search and Filter" database but end up confused. I have also read relevent parts of the Base manual. I have two forms, Graves and Burials, the Graves form covers ownership and registration of a grave and includes a photograph of any headstone which may be on site. The burials form is mainly for burial record keeping. The reason I have decided on two forms is that it allows me to see all the relavent data in one screen. Some specification criteria:- In both the "Graves" and "Burials" forms Plot No., Headstone and owner are to be common. Plot number is the primary key and therefore cannot be duplicated for obvious reasons. The graveyard is laid out in rows eg A to Z. Each grave in each row is given a number in sequence, eg A1, A2, A3 etc. 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. John -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Spreadsheet Formula Query
Hi Folks I have attached a file called "Spreadsheet Query". It is part of a much larger file but the contents will suffice for my question. What should the formula for "K2" be? The formula for L2 is (=COUNTIF($G$2:$G$750,J2)". You will see that Column "L" counts the number of individuals assigned to, in this case James Thompson. I want to find out how many families he is responsible for, column "B" has the information for this, the number of times each number occurs. You will see eg Arnold is a family of 4, parents and two children, Balmer is a family of three. John -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Spreadsheet Query.ods
I've shared an item with you: Spreadsheet Query.ods https://drive.google.com/file/d/0B6Toem0dJhqCWVFOMV9WeUQ5Y0k/view?usp=sharing=COuu9s8M It's not an attachment -- it's stored online. To open this item, just click the link above. -- To unsubscribe e-mail to: users+unsubscr...@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