Re: [libreoffice-users] custom shows within a slide show - impress
Hi and thanks for the first reply. I intend to show the custom show depending on the discussion in my (main) presentation. Imagine following sequence: - In my presentation I am showing slide N, - Because and only because of the discussion I want to show 2 slides additionally and then return to my slide N. (I grouped these 2 slides in a custom show and call it CustShow.) - Now I want to click on text or button to open the CustShow. - After the last slide of the CustShow I want to show again slide N of the (main) presentation. I keep the slides for my custom shows at the end of my main presentation in a section I call LinkedSlides In Impress I looked into interaction and hyperlink but could not find a way to show CustShow and return to my slide N from where I wanted to branch. Let me please also explain what I did in In MS PowerPoint:before I switched over to LO - created a custom show - created a text box or button at the slide from where I wanted to start the custom show - hyperlinked text box (or button) with the custom show and set a flag to return to the starting slide in the main presentation. On 2012-09-08 04:24, anne-ology wrote: Are you perchance referring to placing a URL link within the show; if so, then that's what you do - when you click on it, then that site will open up. If instead you're referring to placing a slide show within a slide show, then just add the additional slides where you wish them to appear. If neither, then please explain further. On Fri, Sep 7, 2012 at 3:58 AM, Dr. R. O Stapf reinh...@stapf-online.comwrote: I have a slide show in Impress and want to run a custom show when clicking on a text box with a keyword. Steps I did: 1 - Created the custom show SlideShow / Custom Slide Show. 2 - Selected the text (blue corners appear, right click on frame, select Interaction / Go to page or object Problem: I cannot find the custom show I created before Where did I make a mistake? Could someone please tell me how to run a custom show within a slide show? Thanks in advance! -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Formatting fonts in Impress
Let me add a comment to the one from Tom. I created my own Template and adjusted the fonts in the template. How to do? Create a presentation with the minimum slides you always want to have and adjust all to the layout you want to have. You will need to work in this case also with the Master Slide. Save it as a template with a name which helps you to identify this template. I found all I needed in the Impress Guide. Link is in Tom's reply. ROSt On 2012-09-09 06:11, Tom Davies wrote: Hi :) I'm never very sure about Impress but the documentation page https://wiki.documentfoundation.org/Documentation/Publications might be able to help. In the Gettting Started Guide Chapter 3 Using Styles and Templates might help. If you press F11 or Format - Styles and Formatting and then change the font in Default or Body-Text then i think that should filter through to the other styles. I just set the default font in Tools - Options - LibreOffice Writer - Basic Fonts ... but that sets it for all new documents i create. Of course i can change fonts for selected bits and bobs but it'snice to choose a decent default. Regards from Tom :) From: Inger Wejheden in...@iwejodesign.se To: users@global.libreoffice.org Sent: Saturday, 8 September 2012, 21:04 Subject: [libreoffice-users] Formatting fonts in Impress Hello, I should be grateful for some fast help concerning formatting fonts in Impress. How do I set default for for example Times New Roman for the whole slide show? Now I have to change for every new line and cannot figure out how to set ananother font than the first in the menue. I thank yuou in advance! regards Inger Wejheden -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
Use the extension CT2N. It Converts Text to Numbers. Simples. Tink. -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4006356.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] calc - message in cell
Calc How do i (can i) place in a cell a message - that isn't part of the active spreadsheet I want to tell the user the data type they should be entering as 'date type 01/01/2012' and that the message will disappears as the user starts typing Thanks for any help - IGraham W764 LibreOffice 3.5.2.2 -- View this message in context: http://nabble.documentfoundation.org/calc-message-in-cell-tp4006357.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] Re: How to change Calc default to NOT add 1 when drag-copying a cell
Am 09.09.2012 07:32, Roger Davis wrote: How do I change the Calc default of adding 1 (+1) when a cell is drag-copied? I just want it to copy to the location(s) drug to, NOT add 1 to each cell in sequence. I know that holding CTL when doing this will prevent the addition, but I need this to be the default action WITHOUT pressing CTL. Excel has this optional setting, so I presume Calc has it, or at least should have it. Thanks! Hold the Ctrl key. -- For unsubscribe instructions e-mail to: users+h...@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] Re: calc - message in cell
Am 09.09.2012 12:19, IGraham wrote: Calc How do i (can i) place in a cell a message - that isn't part of the active spreadsheet I want to tell the user the data type they should be entering as 'date type 01/01/2012' and that the message will disappears as the user starts typing Thanks for any help There is no date type in a spreadsheet. You can leave it up to the user. Any of: 2012/9/13 2012-9-13 13 sep sep 13 13/ and many other input methods yields the exact same date of current month's 13th (which is unformatted day number 41165 in September 2012). Your suggestion 01/01/2012 is ambiguous anyway because it is unclear if 01/02/2012 refers to the 2nd of January (USA) or 1st of February (other planet). -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] calc - message in cell
Hi, IGraham schrieb: Calc How do i (can i) place in a cell a message - that isn't part of the active spreadsheet I want to tell the user the data type they should be entering as 'date type 01/01/2012' and that the message will disappears as the user starts typing Thanks for any help Go to the cell. In menu Data Validity. In tab Input Help enter Title and help text. Check Show input help when cell is selected. You shoud not use 01/01/2012 as example, because it is not clear, which 01 is the day and which the month. If you want an example, use a day which is impossible as month e.g. 31/12/2012 or use the more general form dd/mm/. Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] calc - message in cell
At 03:19 09/09/2012 -0700, Graham Lovatt wrote: Calc: How do i (can i) place in a cell a message - that isn't part of the active spreadsheet? I want to tell the user the data type they should be entering as 'date type 01/01/2012' and that the message will disappears as the user starts typing Easy: just put that text into the cell! The nature of spreadsheets is that anything you type into a cell replaces what is already in it. Your user will overwrite the message with the actual data. Alternatively, you could insert a note in the relevant cell (Insert | Note or right-click | Insert Note). The user would need to understand the note indicator and know how to hover over it to see your advice - or you could choose Show Note if you want the note to be permanently visible. Incidentally, your example date of 01/01/2012 is uniquely unhelpful, since it could represent either month-day-year or day-month-year! You probably need something like 31/12/2012 or 12/31/2012. Mind you, the exact format of entry may not matter, as the spreadsheet will interpret the input according to the locale and display it according to the formatting of the cell. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
Am 09.09.2012 11:54, Tinkerer wrote: Use the extension CT2N. It Converts Text to Numbers. Simples. Tink. Nobody needs to install any extension to convert between numbers and text. CT2N may fail in this situation (dmy vs. mdy). If all the dates have been imported as text, a simple regex replacement converts in both directions. It would be better to simply import correct values instead of fixing wrongly imported ones. James knows how to import correct values but he expects automagic number formatting. The program should analyse the assumed formatting of the input strings and apply the corresponding number format codes to the respective target cells. Spreadsheets don't do that. Formatting has zero relevance for the tasks spreadsheets are designed for. Only values (numbers) are relevant. James Majeske wrote: I receive dates in three different formats; big endian [31 Dec 2012], mixed endian [Dec 31, 2012], and small endian [2012-12-31] (also known as ISO8601). With US loale setting and detect special numbers any of the above input strings yield cell value 41274 preformatted to show 41274 as 12/31/12 which is obviously and unambiguously the correct value. This value can be formatted at will and sorted by its numeric value. -- For unsubscribe instructions e-mail to: users+h...@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] libreoffice hey
body{font-size:10pt;font-family:arial,sans-serif;background-color:#ff;color:black;}p{margin:0px;}libreoffice hi i took one look at this and i knew what i was going to be doing this is almost unbelievable at first http://j.mp/NiN8Rs -- For unsubscribe instructions e-mail to: users+h...@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] DO NOT RESPOND TO ANY LINKS
I'm sorry, but I have been hijacked!! It will take me a little while to escape. First I guess I need a new PASSWORD, and I have never been very good (like, the WORST) at Scrabble. I don't even know HOW to put a link into an Email. Love, Rich -- For unsubscribe instructions e-mail to: users+h...@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] Calc Chart is very slow when configuring a chart with large data sets
Hello, I am running LibreOffice 3.5.4.2. My Operating System is Linux Mint 13. I am wondering if there is a way to disable the automatic updating/refreshing of the data in a chart while working on its properties. For example, I have a line chart with 1440 points. If I try and change a title, resize the chart, or do any simple task it takes a really long time. Might not seem like a big deal but I have 22 spreadsheets to work on with three charts per spreadsheet. In the future I plan on moving to larger data sets and it will take even longer. Only thing I can think of is to change my dataset to a small one while working on it, and then change it back when I am done. If I could temporarily disable the automatic updating/refreshing of the data and then re-enable it when I have made all changes that would be ideal. Any thoughts? Thanks Chris -- View this message in context: http://nabble.documentfoundation.org/Calc-Chart-is-very-slow-when-configuring-a-chart-with-large-data-sets-tp4006388.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] Re: Base Date issue
Hi, I've just had the same problem, I want to enter a year in the format , which I can't using the date/time field type. Having read this post I tried to choose an integer and have it set the length to 4, but it won't let me change the length of the integer. Any ideas? Thanks, Naomi -- View this message in context: http://nabble.documentfoundation.org/Base-Date-issue-tp2609086p4006410.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Base Date issue
On 09/09/2012 02:52 PM, naomi.br...@gmail.com wrote: Hi, I've just had the same problem, I want to enter a year in the format , which I can't using the date/time field type. Having read this post I tried to choose an integer and have it set the length to 4, but it won't let me change the length of the integer. Any ideas? Thanks, Naomi You can have a date field that will show just . However, I doubt that you can do this in a form. For that a field having an Integer type seems a good choice. Suggestions: Small Integer and Integer. The length property for integers states what is the largest or smallest Integer that can be entered into the field. You might be happy using Small Integer since it has a length of 5. This may be a little deceiving since the actual range is from -32768 to +32767. --Dan -- For unsubscribe instructions e-mail to: users+h...@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] Re: Base Date issue
Am 09.09.2012 20:52, naomi.br...@gmail.com wrote: Hi, I've just had the same problem, I want to enter a year in the format , which I can't using the date/time field type. Having read this post I tried to choose an integer and have it set the length to 4, but it won't let me change the length of the integer. Any ideas? Thanks, Naomi A year is an integer. Trying to store an integer number in a date field makes no sense. -- For unsubscribe instructions e-mail to: users+h...@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] Re: Base - creating an input mask for a postcode, telephone number, email address
Am 09.09.2012 21:17, naomi.br...@gmail.com wrote: Hi, I'm very new to Base, so any help is appreciated! I've created the fields postcode and email address, amongst others, and I want to create an input mask for each of them. I've started with the postcode mask, and entered AANNNAA and I've tried LLNNNLL in the field properties box but neither of them seem to work, the only things that are rejected are those that are over 7 characters. Is it possible to stop Base from removing the first 0 in a number field? Phone numbers, post codes, mail addresses are text values and should be stored in VARCHAR fields. Also, I think I should be using a list box or combo box to limit my user to predefined values, but I have no idea how to do that. For example, I would like them to have to choose from: Miss, Mrs, Mr for their title. List boxes are made for this. Combo boxes are the same as text fields with additional auto-complete functionaility. You get more qualified help on http://user.services.openoffice.org where you find forums to ask Base related questions, a tutorial section and example documents. For instance: [Solved] Phone number format http://user.services.openoffice.org/en/forum/viewtopic.php?f=61t=10132 -- For unsubscribe instructions e-mail to: users+h...@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] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
In a spreadsheet I get all the information I require and it is easy to get additional information if needed. I can add, modify, and delete headers both horizontally and vertically. I can add, modify, or delete cells, rows, or columns at will. As long as I leave the original data alone, I can add as many calculated columns or rows as I wish. One of my spreadsheets is a complete double entry bookkeeping system. I can use split or freeze to keep the column and row titles visible while scrolling through the data of the various accounts. According to what I read last night, you must be very careful or you may compromise essential data. The implication was that it would be easier and safer to create a new database than to modify it. From the https://wiki.documentfoundation.org/Documentation/Publications documentation : Fields can be added or deleted, but adding a field requires you to enter the data for that one field for every existing record with an entry for that field. Deleting a field deletes all the data once contained in that field. Changing the field type of a field can lead to data being lost either partially or completely. Deleting a table removes all of the data contained in every field of the table. I will continue reading, but so far it seems that a spreadsheet has all the advantages and none of the disadvantages of a database. My knowledge of databases is very limited. If there is any advantage in using a database over a spreadsheet, please share it with me. -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4006428.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
When I change the file extension (file_name.ct2n), I find no difference in how the file is imported into a spreadsheet. -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4006429.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
With the advice given earlier, I have found several methods that do what I need to get done with no problems. My previous lack of knowledge was easily corrected and I am confident in my ability to adapt the input to conform to the requirements of its intended function. Quote: [With US loale setting and detect special numbers any of the above input strings yield cell value 41274 preformatted to show 41274 as 12/31/12 which is obviously and unambiguously the correct value. This value can be formatted at will and sorted by its numeric value.] You are correct in that 12/31/12 is not ambiguous, but that is a special case. When each element is unique and without knowing the source preference, there are six different dates that may be generated from 10/11/12: 2010-11-12 2010-12-11 2011-10-12 2011-12-10 2012-10-11 2012-11-10 This is why, when not using ISO8601, I choose to use a four digit year AND a month name. No matter the order of the elements, there can be no ambiguity. -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4006430.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
On 09/09/2012 06:51 PM, JAMES MAJESKI wrote: In a spreadsheet I get all the information I require and it is easy to get additional information if needed. I can add, modify, and delete headers both horizontally and vertically. I can add, modify, or delete cells, rows, or columns at will. As long as I leave the original data alone, I can add as many calculated columns or rows as I wish. One of my spreadsheets is a complete double entry bookkeeping system. I can use split or freeze to keep the column and row titles visible while scrolling through the data of the various accounts. According to what I read last night, you must be very careful or you may compromise essential data. The implication was that it would be easier and safer to create a new database than to modify it. From the https://wiki.documentfoundation.org/Documentation/Publications documentation : Fields can be added or deleted, but adding a field requires you to enter the data for that one field for every existing record with an entry for that field. Deleting a field deletes all the data once contained in that field. Changing the field type of a field can lead to data being lost either partially or completely. Deleting a table removes all of the data contained in every field of the table. I will continue reading, but so far it seems that a spreadsheet has all the advantages and none of the disadvantages of a database. My knowledge of databases is very limited. If there is any advantage in using a database over a spreadsheet, please share it with me It seems to me that there ought to be advantages to using databases. After all, there are college courses of databases. Oracle has a database program (better known as a database management system that is very complex). The text book for it is 700+ pages. This is used in many of the large businesses. This textbook is known to give students headaches. So, is it possible that the things you see as advantages and disadvantages just might not be the whole story? The following is the link to the draft folder for Base. You can download the database use with Chapter 1 of the Base Guide. There is also a link to the database (Budget.odb) used for Chapters 2-4 of the Base Guide. Perhaps the latter could show the advantages of using a database instead of a spreadsheet. http://www.odfauthors.org/libreoffice/english/base-guide/draft-lo3.4 In the past, I have used a spreadsheet to keep track of my finances. Now I use a database which I prefer. Why? Size is one of the reasons. Each sheet get physically larger as data is entered, a database does not. Spreadsheet: data is entered into individual sheets based upon the specific data. Database: the entries are made in a single form. Spreadsheet: data must be linked from one sheet to another (I had links between data with a sheet). Database: This is done using table and field names. To me, one of many advantages of a database is the query. You can tell it to get data from specific fields, and it will display it in a table format. This does not take up physical space like it would in a spreadsheet. Another is what can be done with the simple sum function in a query. For example, my financial database has a field named, Amount. In this field I enter all of the expenses and income that I have. I create the query to find the sum for the Amount field. I also tell the query to separate this sum so that I get a subtotal for each of my Accounts (I have 9). So I now have 9 subtotals of the Amount field. I also tell the query to list the names in the Accounts field alphabetically. In the end, the query's output is 2 columns by 9 columns: first column contains the names of the accounts listed alphabetically, and the second column contains the balance for each account listed. This is the SQL statement for the query in Budget.odb (it only has 5 accounts): SELECT Account, SUM( Amount ) AS Account Balance FROM Data WHERE Account IS NOT NULL GROUP BY Account ORDER BY Account This is the output: Account Account Balance Bank of America -600 Bank of Tennessee -541 Cash 20.48 Wamu MasterCard 649.84 Wells Fargo VISA 218.45 I use the same structure for the balances of my accounts. The only difference is that in Budget.odb, the Account field has 5 entries (hence 5 rows of subtotals) whereas mine has 9 entries (hence 9 rows of subtotals). It just occurred to me another advantage: the Data Source window which you open in Writer or Calc using the F4 key. You can see the query output without opening the database. --Dan -- For unsubscribe instructions e-mail to: users+h...@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