3 Replies Latest reply on Feb 24, 2016 4:03 PM by nmkur1

    Calculation

    nmkur1

      Hi All, I want to take result of Rate * Hours. The rate and hours stored in two tables. How can I perform this calculation? Thank you

        • 1. Re: Calculation
          siplus

          without seeing your relationship diagram and knowing where the result will go it's hard to say.

          • 2. Re: Calculation
            glennsingleton

            If you had say a

            Rate Table with fields like

            • Rate ID
            • Rate Amt

            and a Employee Table with Fields

            • Employee ID
            • Rate ID    --> form a relationship to [Rate Table::Rate ID]
            • Name

            and a Employee Hours Table with fields

            • Employee ID  -->form a relationship to [Employee Table::Employee ID]
            • Date_Time
            • Hours
            • Pay (calculation) = Hours * [Rate Table Relationship::Rate Amt]

            Each record in the Employee Hours table would be an entry for any Employee and pick up the rate from Rate Table.

            Is this the sort of thing you are after? Of course your requirements could be different ...

            • 3. Re: Calculation
              nmkur1

              Hi glensingleton,

              Thank you so much for your answers, that what exactly i wanted.

              Thanks again