Hello-
I have place the following statement into field area of a query:
Expr1: (SELECT MAX(DateAdd('yyyy',-1,DateSerial(Year([EDRMPeriod]),Month([EDRMPeriod])+1,1))) FROM EDRAppC GROUP BY EDRCHPlan)
I ran this select statement in queryman and it returns the results I want.
When I try to place it here I get a message that this will only return one result. In queryman it returns a max date for all grouped entries. I want to take the max date and compare other dates to it for report printing.
Thanks for any help.
k
I have place the following statement into field area of a query:
Expr1: (SELECT MAX(DateAdd('yyyy',-1,DateSerial(Year([EDRMPeriod]),Month([EDRMPeriod])+1,1))) FROM EDRAppC GROUP BY EDRCHPlan)
I ran this select statement in queryman and it returns the results I want.
When I try to place it here I get a message that this will only return one result. In queryman it returns a max date for all grouped entries. I want to take the max date and compare other dates to it for report printing.
Thanks for any help.
k
