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...
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...
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...