Hello,
I've got a project that I'm having some trouble with. My client has a program that only allows for 5 logins and more than 5 people using these logins. He had been using an excel sheet to map who was using what login at what time, problem is that he doesn't have this information readily available. The assumption for this project is that each login will be used by only one person in any given day. I was thinking just a button that a person would click to specify that they are using that login for that day, this would add a new row to a database which would contain datetime, name, login number, and action. I figured this way would be best because each action has it's own data instead of each day having data.
I'm having trouble taking the log of data and converting it into a cross-table with day on the left and login number on the top. I am normally pretty good at figuring things out when it comes to database structuring and query's but I can't seem to get this one.
Any help would be greatly appreciated.