Dsum criteria

  • Thread starter Thread starter Alain
  • Start date Start date
A

Alain

Hi to all, need some help with this Dsum function, the syntax seem to be
fine but when I run it it give me an error
this function is being used in a report.
my goal here is to be able to sum some totals in groups of 5 years period,
the period will always changed from fiscal year to fiscal year
I do not know if there is a better way to do this but I'm open to any new
concept

DSum("Amount","[Q-ProjectionTOC]","Annee BETWEEN MIN(Annee) AND
(MIN(annee)+5)")

Thanks

Alain
 
I have also tried the following

=DSum("Amount","[Q-ProjectionTOC]","Annee BETWEEN
DMin("[Annee]","[Q-ProjectionTOC]") AND
DMin("[Annee]","[Q-ProjectionTOC]")+4")

but this time it give me an syntax error

TIA

Alain
 
Back
Top