Deborah Davidson wrote:
I'm new to o0o and with the help of Dai's tutorials found here
<http://showmedo.com/videos/?author=1922> (Thanks Dai !)
been trying to set up a database for my "Daily Call Log Sheets" with
Base.
However I'm totally lost about how to add the time spent with each
client automatically.
Here are the fields I've set up
1. ID ..................................(primary Key = No input)
2. Date ...............................(Input Date)
3. Start Time .......................(Input Time)
4. End Time ........................(input Time)
5. Clients Name ..................(input Name)
6. Allocated Time ................(No input - just adds time from
Start & End times)
7. Total Time .......................(No input - running total of
allocated times)
Not sure if you asked on the DBA mailing list, but in case you did not,
I will make a few vague comments without checking (and without checking
myself, I am not sure of the best solution).
So field 6, Allocated Time is something like [End Time] - [Start Time].
The problem I see with allocated time, is that it is computed so there
is no real reason to store the value (unless it is really needed for 7).
If [allocated time] is stored, you must take care to prevent the values
from becoming out of synchronization with fields 3 and 4.
Where do you want to display fields 6 and 7? A report, or on a form?
My opinion is that you should NOT store this field, but rather, compute
the values when you need/desire them. A report, you should be able to
specify the statements to calculate these things.
If I were to attempt to solve this problem, my first attempt would be to
try a field that obtains its value as a SQL statement based on fields 3
and 4. If that did not work, then I would use a Macro to pull the values
and compute the SUM.
It looks like the Total Time is a summation from multiple fields grouped
by client name. This is more difficult yet... And my wife is asking for
help with our newborn... We are at a level 2 snow emergency and missing
a Dr. appointment <sigh>.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
