Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2021
    Posts
    8

    Question Is PERT analysis possible in MSAccess?


    The formula for project evaluation & review technique (PERT) is Optimistic +(4*MostLikely)+Pessimistic/6. My goal is to add a field to automatically calculate this based on the min, max & average durations of actual tasks. For example, to find the PERT for inspections, I tried to use =[MinInspection]+4*[AvgInspection]+[MaxInspection]/6, but I get a #Name error message. Any suggestions would be greatly appreciated.

  2. #2
    Join Date
    Apr 2021
    Posts
    8
    FWIW, I have also tried these variations of the same formula:

    =[MinInspection]+(4*[AvgInspection])+[MaxInspection]/6
    =([MinInspectiong]+4*[AvgInspection]+[MaxInspection]/6)
    =([MinInspection]+(4*[AvgInspection])+[MaxInspection]/6)
    =([MinInspection]+(4*[AvgInspection])+[MaxInspection])/6

  3. #3
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    If your questions is can you do this in the table as a calculated field I would not. It's better practice do calculations in a query instead. This is simple arithmetic, access wont have any problems.

    Regarding #Name error message that is telling me that maybe one of your field names is mispelled? either in the formula or the actual name of the field. (strictly speaking access doesn't care about literal spelling, what I mean is a field name in a formula doesn't match up character-for-character to the table's field name.)

  4. #4
    Join Date
    Apr 2021
    Posts
    8
    Nevermind! I removed the brackets & it works! Thanks anyway.

  5. #5
    Join Date
    Apr 2021
    Posts
    8
    You are fantastic for trying to help. Thanks! I am adding this formula to a report.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. ODBC Log Analysis
    By ian@artsalive.co.uk in forum SQL Server
    Replies: 7
    Last Post: 08-19-2021, 11:02 AM
  2. Replies: 2
    Last Post: 11-04-2017, 05:06 PM
  3. Learn MSAccess by playing MSAccess Jeopardy
    By pkstormy in forum Sample Databases
    Replies: 4
    Last Post: 11-17-2016, 07:27 AM
  4. Relationship Analysis
    By Alexieoo in forum Database Design
    Replies: 67
    Last Post: 10-26-2015, 12:51 PM
  5. Trend Analysis
    By TimC in forum Queries
    Replies: 2
    Last Post: 01-05-2015, 11:58 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums