Search results

  1. M

    Dsum issue

    I would like to know if this is possible? my report date is in 1 table and my data is in a seperate table. I would like to sum my hours from the Appleton table from a date range in the YearMonth table Public Function CorpRIR() Dim mySum Dim begD As Variant Dim endD As Variant Dim number...
  2. M

    Sum last 12 rows for calculation

    Good Afternoon, I am a new to Access. I was hoping someone would be kind enough to help me with an issue I am facing. I have a table with 4 columns: ID (1,2,3,4,...),Cases, Hours, RIR. In the RIR column I would like to use the following formula. I would like to use a query to Sum the last 12...
  3. M

    Sum last 12 rows for calculation

    Good Afternoon, I am a new to Access, but have programmed in Excel. I was hoping someone would be kind enough to help me with an issue I am facing. I have a table with 3 columns: Cases, Hours, RIR. In the RIR column I would like to use the following formula. Sum the last 12 rows in the cases...
Top Bottom