Recent content by rplum80

No need. Figured it out. Thanks

Sorry should have been more specific. If between January 1st and January 30th, then the period = 1. If between January 31st and February 27th, then the period = 2. etc Something similar to the attached. (ignore Colleague_number) column.

Hey Guys! I don't know enough of Access to figure this one out. I am trying to calculate Periods in a calendar year through a query. Basically we have 13 periods in a year, here is the breakdown starting from January 1st 2016. Weeks 1 - 4 = Period 1 Weeks 5 - 8 = Period 2 Weeks 9 - 12 =...

When I run the query after entering your statement it now flags the ESA Days with a -1. Regular Hours is 0.

Here is the query. SELECT dbo_VP_TOTALS.PERSONNUM, dbo_VP_TOTALS.PERSONFULLNAME, dbo_VP_TOTALS.PAYCODENAME, dbo_VP_TOTALS.APPLYDATE, Format([APPLYDATE],"dddd") AS [Week Day], dbo_VP_EMPLOYEE.HOMELABORLEVELDSC5 AS Department, Left([GRPSCHEDNAME],3) AS Shift, dbo_VP_EMPLOYEE.ACCRUALPRFLNAME AS...

Hey guys!, I need a little help and was hoping someone could assist. We are tracking our employees attendance at work, and I built an access database that pulls from our time keeping system however on some instances its pulling the wrong data because a different record is present besides there...