3 Replies Latest reply on Feb 24, 2016 4:03 PM by 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

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

          • 2. Re: Calculation

            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

              Hi glensingleton,

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

              Thanks again