OHH yeah, you read that correctly.
So, as a stop gap I built a quick Sharepoint List to track attendance for approximately 2400 employees. Well, 9 months later they havent gotten a smarter person to do this.
Keep in mind I am military and this tracks specifics on personnel location so I cannot share the actual DB with anyone.
Ill try to explain what I am doing....
I have 31 fields, (1,2,3.....31) one for each day of the month.
Their are 15 options for each day on what the duty status is.
I have queries built for daily reports I do for the leaders that lists how many people are at work, how many are teleworking, how many are on leave, etc etc etc.
Problem is I modify my queries EVERY DAY.
Tomorrow morning I will modify 6 queries and change [19th] to [20th].
Is there a query I could build, like a macro almost, that will update a query field.....
Im thinking I open with a form that has a simple drop down with 1,2,3....31 and if I select 20 and hit enter, then THAT initiates an update of all queries and
SELECT [PerStat v1].[19th]
becomes
SELECT [PerStat v1].[20th]
As I type this, i am thinking its probably much simpler than I think...
PLEASE understand, this was a 1 hour process to build initially, and was again supposed to be temporary. For 150 personnel to be making changes to their personnel daily, giving them an access database front end would have been a nightmare. People dont know and are afraid of Access. so a simple website where they sort their folks and select a drop down was a MUCH better option from my end for the short term, which has now become the standard. IF you want to sharpshoot my methodology, please feel free to provide me a better solution or point me in the right direction as well.