In a volunteer database at the hospital I have two fields, the first
one being hours worked last year and the second one being total hours
worked for that volunteer. Is there a way to change the first field
to the hours worked for each year as we change years and have it
change the second field by just adding those hours to the number that
is already in the field?
I have approx. 200 volunteers and it would save me from having to
change both fields.
Thanks for any info.
Rocky

Rocky,
You could have a button that you could push every year or set the code
to check the date anytime the database is opened.
You will need an if statement similar to the following:
If Date = January 1 Then
totalhrs = totalhrs + hrsworked
hrsworked=0
End If
Hope that helps.
Kara

www.klh-tech.com
KLH Technology Solutions

Rocky <rockfish (AT) home (DOT) ca> wrote

Kara the numbers for the past year are added a month or so after the
end of the year after they are added up from cards that are kept by
each volunteer. When that number is put in the field it replaces the
number from the year before. That is when I need it to be added to
the number of total hours in the next field. Can that be done?
Rocky

On 16 Feb 2004 12:48:14 -0800, karahooper (AT) hotmail (DOT) com (Kara Hooper)
wrote: