I have three tables created in access...
1 from a legacy system that has bargaining unit workdays by EMPLID {impl_ID}
1 From a PS Query that has All Active EMPLID's
{Current_ID}
And 1 From a spreadsheet showing adjusted BU days (in negative numbers)
{Adjusted_ID}
I need to write a formula that checks if the current ID is in the impl_ID table and if it is in the adjusted table and get the sum of the three day values.
Then I need to see if the EMPLID is in either the impl OR Adjustments and get a sum of those days
and then I need to get a sum from those IDs that are only in current (workdays from hire date to today)
Sorry for the length of this but I am stuck. I keep getting errors.
1 from a legacy system that has bargaining unit workdays by EMPLID {impl_ID}
1 From a PS Query that has All Active EMPLID's
{Current_ID}
And 1 From a spreadsheet showing adjusted BU days (in negative numbers)
{Adjusted_ID}
I need to write a formula that checks if the current ID is in the impl_ID table and if it is in the adjusted table and get the sum of the three day values.
Then I need to see if the EMPLID is in either the impl OR Adjustments and get a sum of those days
and then I need to get a sum from those IDs that are only in current (workdays from hire date to today)
Sorry for the length of this but I am stuck. I keep getting errors.