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.
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.