Hi Macropod
This is Needs Direction again. I do not know if I have sufficiently let you
know how inept I feel right now. Here is a copy of what I seem to be able to
achieve and it does not look like anything I hear you describing. I think I
may not have the right base table that you are referring to.
Totally defeated,
Needs Direction
PS Oh my goodness I cannot even tell how to attach a word document to this
post!
"macropod" wrote:
Hi Bill,
Which fields are you referring to? On my system this first set of fields on
page 9 are headed 'Calculate the # Days Difference Between Two Dates'. Your
original post indicated you wanted to calculate someone's age, for which the
field headed 'Calculate A Person's Age' would seem more appropriate.
As for using the fields, the example under the heading 'Calculate the # Days
Difference Between Two Dates' takes it's input from two bookmarked fields,
named 'StartDate' and 'EndDate', respectively. As coded, that field isn't
interactive, but could fairly easily be made so by replacing the existing
'StartDate' and 'EndDate' cross-references in the with ASK fields to solicit
the 'StartDate' and 'EndDate' values. The ASK field that presently solicits
the 'StartDate' for this example is actually located in cell A1 in the table
under the heading 'Date Calculations in a Table'. The 'EndDate' value is
bookmarked on the same line as the formula field.
To use the field under the heading 'Calculate A Person's Age', simply select
it and press F9, as per the instructions at the front of the document. The
instructions also provide other useful information for viewing/working with
the field coding.
Getting these fields to work interactively in a table would require some
modification and would best be done using a Formfield in each cell requiring
input (you may only need to solicit the birthdate, since the date of the
calculation can be obtained from the system) and putting the table into a
section that is 'protected for forms'.
If you post back more details about the document & data you're working with
and what you're trying to achieve, it shouldn't be too difficult to find a
solution.
Finally, you might see where the bookmarks and fields are more easily if you
go to Tools|Options|View and:
.. check the 'bookmarks' box
.. set the 'Field shading' property to 'Always'.
Cheers
"Needs directcion" wrote in
message ...
Hi Macropod
I feel very infantile but I have virtually no computer skills when it
comes
to anything more then simple word processing skills. I feel that this
should
be easy and downloaded your tips and techniques but still find myself
struggling to recreate any of the things you describe. I need a simple
two
or three column date formula. It would seem that you have an example
almost
like what I am trying to create. I tried copying and pasting it (top of
page
9) as a last resort and hoped to just modify to fit my needs. Butt.....
for
one thing I can not seem to find anywhere click that says show book marks.
If you have the time to give me an example in word that I could insert in
a
table to try out that would be absoulutely great!. I need a colum where I
can type in the date a client was referred to our program ( we like Feb.
3,
2005) type of thing then a column that calculates this first column from
from
an automatically updating Today's date. So what I need is the numbers of
days a client is waiting for service on the date that we open that file.
I
am sorry to bother you about this but it would make such a difference to
our
work load and I feel that it is at the tip of my fingers to do this and I
can
not seem to make it work.
Please help if you can.
Needs Direction
"macropod" wrote:
Hi Bill,
To see how to do this and just about everything else you might want to
do
with dates in Word, check out my Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=249902
Cheers
"Bill" wrote in message
...
Is this possible in a Word table?