G
Gwen H
How do I change the snipped of SQL code below to force it to always choose
the last month?
Last(Iif(Assistant_Retail_Manager_Activities.Month BETWEEN #01/01/2005# AND
#03/31/2005#,Assistant_Retail_Manager_Activities.Deposits_Outstanding,0)) AS
DO_Qtr1
This is from a quarterly query that sums some fields, and is *supposed* to
use the last month's numbers on other fields (mixture of "sum" and "last").
The problem is, if we filter and sort the table from which the results come
in different ways, then Last doesn't always pick the last month's data.
Instead, it picks what it interprets to be the last entry in the result set.
Thank you!
the last month?
Last(Iif(Assistant_Retail_Manager_Activities.Month BETWEEN #01/01/2005# AND
#03/31/2005#,Assistant_Retail_Manager_Activities.Deposits_Outstanding,0)) AS
DO_Qtr1
This is from a quarterly query that sums some fields, and is *supposed* to
use the last month's numbers on other fields (mixture of "sum" and "last").
The problem is, if we filter and sort the table from which the results come
in different ways, then Last doesn't always pick the last month's data.
Instead, it picks what it interprets to be the last entry in the result set.
Thank you!