Search results

  1. F

    Creating a Running Total for Each Record

    Thanks Arnel. This works!
  2. 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...
  3. F

    Creating a Record for Each Customer for Each Period

    theDBguy - Thank you. This works! Pat Hartman - I was provided with the monthly revenue value for each customer subscription contract. I need to compare each period (month) from each year to December from the prior year. Unfortunately, the dataset provided to me only goes out to the end of each...
  4. F

    Creating a Record for Each Customer for Each Period

    "Short Text" type field. I am flexible and can either change it to a "Date" type field or create a new field that is "Date" type if that helps.
  5. 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