After some tinkering, I was able to create a database that will do
at least some of the things you want it to do. In the end, I created a
form that contains (as the main form) the Author's name, Book Title,
Editor's name. As the sub form, it shows the query results which include
Date Assigned to the Editor, Date Editing Completed, Due Date, Days of
Editing allowed, Days of Editing done.
Is this something that you could use? I could send it to you off
list.
With your mathematical background, perhaps you will be able to
follow my logic in the way I created the queries and tables.
--Dan
On Wed, 2012-02-01 at 19:44 -0800, Jeffrey Needle wrote:
> 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
