I have 2 queries. The results of Query1 are:
Revenue_Month (text)
Revenue_Year (number)
RevenueDate (Date)
Legacy_Bucket (text)
Legacy_Prod (text)
ProdRevType (text)
RevenueAmt (number)
Query2 Results:
Assumption_Month (text)
Assumption_Year (number)
AssumpDate (date)
Legacy_Bucket (text)
Legacy_Prod (text)
ProdRevType (text)
CurrFcstAmt (number)
I created a new query and I joined the two queries by Legacy_Bucket, Legacy_Prod and ProdRevType. I want a query result that will show the RevenueAmt for each month but then I also in that same query want to create a field called AssumptionAmt that for each month is the RevenueAmt for the PREVIOUS month plus whatever is the CurrFcstAmt field for the current month. Help me, please! :banghead:
Revenue_Month (text)
Revenue_Year (number)
RevenueDate (Date)
Legacy_Bucket (text)
Legacy_Prod (text)
ProdRevType (text)
RevenueAmt (number)
Query2 Results:
Assumption_Month (text)
Assumption_Year (number)
AssumpDate (date)
Legacy_Bucket (text)
Legacy_Prod (text)
ProdRevType (text)
CurrFcstAmt (number)
I created a new query and I joined the two queries by Legacy_Bucket, Legacy_Prod and ProdRevType. I want a query result that will show the RevenueAmt for each month but then I also in that same query want to create a field called AssumptionAmt that for each month is the RevenueAmt for the PREVIOUS month plus whatever is the CurrFcstAmt field for the current month. Help me, please! :banghead: