April 8, 201015 yr Hi all... I am working on making a time clock for my company. Everything is working fine thus far except calculating how many hours for the current pay period. I have 2 fields, one containing the begin date, and the other, the end date, I then have a calculation field for calculating the hours in that period. Given that each week is on a separate record, and our pay periods are 2 weeks, how can I make a calculation look across multiple records within a certain date range?
Create an account or sign in to comment