0

Formula need

I need a fórmula on 'Spend Hours' field that adds the sum for each 'Activity Name' for Disciline cumulative, on 'History Hours' table here the name is 'Activity:'

Activities don't have any relations.

Appreciate.

2 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    Looking at a DB you sent earlier, the two fields you mentioned, Activities.'Activity Name' and 'History Hours'.'Activity', I don't see any similar data so I don't know how you can find related records. For example in the Activities table there is a record with a name of 'Civil General'. The in the 'History Hours' table there is no record with 'Civil General' in the 'Activity:' field.

    In the 'History Hours' table there is a reference field called 'N1_Activities' but it is empty for all records. Did you plan on using that to link 'History Hours' to Activities?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

       Hi Fred. Happy Sunday.

      Yes I planned using the link History Hours to Activities, but does not work as I want., it to be updating every time I enter information in 'History Hours'.