Paid Time Off Database

[OU18]

Here is my problem:

I have a database that I am building that will track Paid Time off. I want the database to automatically add 4.62 hours each payperiod to the PTOGranted field.

I have a table (PTOPaySchedule) that contains all the Pay Dates (field name PayDay). I have another table (PTOInfo) that contains all the other fields including PTOGranted.

I am having trouble getting the tblPaySchedule to update the PTOInfo Table.

I am sure there is a simple solution, yet I am having a brain lapse.

Thanks in advance for any help.

stephan.o'rourke@lglass.net