• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Manpower using Access (1 Viewer)

m4ul2o

New member
Local time
Today, 04:53
Joined
Apr 2, 2014
Messages
2
I've introduced me some minutes before and I've explained what I'm Chilean, for this reason, sorry by my bad english.

I think it's possible that a database is not the best idea to develop an staffing plan, but I prefer to know your opinion before to put away it.

I have my database split by position and names and the most of relevant information, however my issues started when I try to think what to do with every week. We have something about 200 persons working in my project.

I though to use one field with dates called "Week" to select a week, but we have about 150 weeks in our project, and to select 200 times into 150 registers and add man hours 150 times I think is a lot of work.

If I create a lot of fields (one by week) I think we would lose the flexibility to cross information, to make maths for instance.

Is a bad idea to use a database to resolve this kind of issue? Or there are some ways to resolve a manpower? Or Excel is my BBF for this kind of problems?

Thanks, and again, sorry by my bad english.
 

spikepl

Eledittingent Beliped
Local time
Today, 13:53
Joined
Nov 3, 2010
Messages
6,144
Define better to the readers what you want - it is a bit difficult to guess.

Is it a time sheet application? Is it roster? Give examples with minimum numbers and screenshot of your tables in the relations window numbers to illustrate what you want. You may need to zip the pictures due to your post count <10.

Also, why do you wish to develop something that can be bought commercially, with web and mobile access, roster/time sheet accounting etc, and that has been tested and verified?
 

Users who are viewing this thread

Top Bottom