copying field contents to another table

[Theresa]

I volunteer for a non-profit service organization.

I have to keep track of personal information in one
table. In another table I need to list all the members,
and then keep track of their volunteer times.

I know how to bring the names in one at a time as I enter
time for each family.

What I want to do is have the names already in the second
table, (there are about 530 families) so all I have to do
is move down the list and put in the hours volunteered
for each month.

How would I do that?

I am using Access XP.

Thanks for your help

Theresa

 

[Jeff Boyce]

Theresa

Access is a relational database -- there's rarely a need to "copy" the same
information (i.e., name) into a second (or third, ...) table. Instead,
recording the primary key ID from your person table in you tblVolunteerTime
gives you a "pointer" back to the person's name -- use a query to show who
just volunteered 20 hours.

Also, when you describe "hours for each month", that makes it sound a little
like you have multiple fields for "month info" (e.g., JanuaryHours,
FebruaryHours, ...). If so, again, consider normalizing your data to take
better advantage of the relational features of Access.

Or, if what you really need is a spreadsheet, use that instead of Access?!

Good luck

Jeff Boyce
<Access MVP>