How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask NewITZone Your Own Question
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

Would really like some advice with how to have an Access or

Customer Question

would really like some advice with how to have an Access or SharePoint 2013 query where I have the following project details - start date number of weeks to complete and % of effort required
I would then like to have this information populated in actual hours across the number of weeks from the start date
Example
Start date 01/01/2016 Number of weeks to complete = 10 weeks % of effort = 30%
01/01/16 = 1 1/2 dpw
08/01/16 = 1 1/2 dpw
15/01/16 = 1 1/2 dpw, so on for each week of the 10 weeks up to 02/03/16
I would also like to include another criteria also, where there is a lag to start date or effort occurs 4 weeks out from end date -
Example from the above - start date is 01/01/2016
duration is 10 weeks
end date is 02/03/2016
Effort is 10% for 4 weeks = 2 weeks at start and 2 weeks before end date.....
01/01/2016 = 1/2 dpw
08/01/2016 = 1/2 dpw
17/02/2016 = 1/2 dpw
24/02/2016 = 1/2 dpw
Would greatly appreciate any expert assistance with this one.
Submitted: 1 year ago.
Category: Microsoft Office
Customer: replied 1 year ago.
Hi, understand my question is not so simple, however your site has directed me to a free week trial before paying a monthly charge to have my questions answered within 30mins and alerting me to the fact an expert had been assigned to my question.......That's been over 8hrs ago with no further response in answering my initial question.......So when can I expect my initial question to be answered and what criteria makes up the $60+ for a 30min response???????
Expert:  ronelgreaves replied 1 year ago.

Good morning, perhaps I may be able to answer your question

Expert:  ronelgreaves replied 1 year ago.

I see that you are trying to decide whether you will use Access or SharePoint to facilitate this process. Have you decided which platform you want to use? The Platform will dictate our approach to your business problem

Customer: replied 1 year ago.
Morning - using Access as the database of choice

Related Microsoft Office Questions