Well, I need to set aside time to see if it all will work. I'm not at all negative about the idea, and yes, my background is in mathematics.
Thanks for all the help. ----- Original Message ----- From: "Dan Lewis" <elderdanle...@gmail.com> To: users@openoffice.org Sent: Wednesday, February 1, 2012 6:07:57 PM Subject: [users] Re: My database woes How do you know they won't do what you want to do? Have you given up before you even try them? I have a form in which I can enter information into a table and also has the results of a query based upon that table. When I enter data into the table, the query updates itself. Planning/Designing a database takes time. I gave you one way to get what you wanted with some limitations. There are other ways to do it. Sometimes it pays to have a good mathematical background to accomplish what you want to do. For example, you mentioned that you needed to know what date is a specific number of days after a given day. You also mentioned needing to know the difference between two dates. Base has a function DATEDIFF that can be used to do both of these things. In the second one, you will need a table that contains the beginning and ending dates. This function will tell you the difference. In the first case, you need two fields: one for the beginning date, and another field contains dates into the future for the ending date. Then the query can use DATEDIFF('dd',beginning date,ending date) = n where n is the number of days. With some time, I can probably create what you want. But then again, I think I can do it. If you have a math background as it sounds like you do, you should be able to do it also. But if you don't think you can, you won't. One more thing. Another thing. Base uses the HSQLDB database engine version 1.8. The online User Guide is here: http://hsqldb.org/doc/guide/guide.html. Chapter 9 has the built-in date functions and how to use them. I could also send you a copy of the user guide for HSQLDB 1.8. It is a PDF. --Dan On Wed, 2012-02-01 at 13:53 -0800, Jeffrey Needle wrote: > Thanks so much. These are a help. Queries are good, but they don't > end up doing what I really want to do -- just enter the data in a form > and have the calculation done for you live. Other pages you offer give > me some ideas. Many thanks again. > > ----- Original Message ----- > From: "NoOp" <gl...@sbcglobal.net> > To: users@openoffice.org > Sent: Wednesday, February 1, 2012 12:13:59 PM > Subject: [users] Re: My database woes > > On 01/31/2012 06:02 PM, Jeffrey Needle wrote: > > Using OpenOffice 3.2 on a Linux system. > > > > This may sound a bit like a whine; it's actually a plea for help. > > > > OpenOffice's database has some fine features, but, amazingly, you can't > > do simple calculations -- especially date calculations -- in the > > database module. > > Sure you can: > <ttp://openoffice.blogs.com/openoffice/2007/03/creating_calcul.html> > <http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/Creating_queries_and_reports> > More: > <http://www.google.com/#sclient=psy-ab&hl=en&source=hp&q=openoffice+%2Bbase+%2Bcalculations> > and for dates, try: > <http://www.google.com/search?sclient=psy-ab&hl=en&biw=1173&bih=675&source=hp&q=openoffice+%2Bbase+%2Bdate+%2Bcalculations&pbx=1&oq=openoffice+%2Bbase+%2Bdate+%2Bcalculations> > Samples: > <http://user.services.openoffice.org/en/forum/viewtopic.php?t=6754> > <http://www.oooforum.org/forum/viewtopic.phtml?t=67907> > <http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures#Date_and_Time_Functions> > > ... > > -- > ----------------------------------------------------------------- > To unsubscribe send email to users-unsubscr...@openoffice.org > For additional commands send email to sy...@openoffice.org > with Subject: help -- ----------------------------------------------------------------- To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help