Updating the value of table based on the sum of another (1 Viewer)

I've got two tables
employees
accrualofdaysLOG

I'd like to set it so employees.personal for each employee equals the sum of all entries in accrualofdaysLOG where the accrualofdaysLOG.type = "p" for that employee. Any ideas on how to do this? Thanks!

Tables are structured as follows:
employees
ID
vacation
personal
bday

accrualofdaysLOG
ID
employeeid
type
numberofdays


Also, are there any great resources online for VBA in access? I've used VBA in Excel a ton, but am having a hard time finding useful resources for Access.

Is there a particular reason why you want to put store a value that can easily be calculated at run-time?

Also, I've found this forum to be the best source of any info on access or VBA.