Search results

  1. F

    Creating a Running Total for Each Record

    With the four columns on the left down below, I want to be able to populate the fifth column (Year to Date Revenue): Subscriber Month Year Monthly Revenue Year to Date Revenue Apple 1 2020 $100 $100 Apple 2 2020 $300 $400 Apple 12 2020 $1,250 $1,250 Pepsi 1 2020 $200 $200 Pepsi...
  2. F

    Creating a Record for Each Customer for Each Period

    I'm an advanced user of Access for someone in corporate finance, however a novice compared to those in technology. I've gotten by with simple queries and basic SQL language. I have a list of about 400 customers. I would like to create a record for each customer, for each month. For example...
Top Bottom