Forum Discussion

StevenPearson's avatar
StevenPearson
Qrew Assistant Captain
5 years ago

Summary Field

I'm trying to create a table to record hours for truck drivers in our company. Each day, they record hours worked and hours driven, along with the date, truck number, etc. One of the columns on the sh...
Relationships
PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
5 years ago

I think I see what you're asking.  Are you trying to get the totals for the week?

I have a formula that will work for you, but need to know a little more about your table structure.  Please describe the fields you are using.



------------------------------
Paul Peterson
------------------------------
  • StevenPearson's avatar
    StevenPearson
    Qrew Assistant Captain
    5 years ago

    This is the table. I need the Weekly Hours Summary to total each week, then the overall total at the bottom will work fine for the month.
    Not a complicated table, just that one field is stumping me.


    ------------------------------
    Steve Pearson
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      5 years ago
      Are the drivers working Monday - Friday?

      ------------------------------
      Paul Peterson
      ------------------------------
      • StevenPearson's avatar
        StevenPearson
        Qrew Assistant Captain
        5 years ago
        For the most part yes. Once in a great while, they'll work on a Saturday.

        ------------------------------
        Steve Pearson
        ------------------------------