Dsum criteria

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need help with DSUM 3
DSum Criteria Question 2
Need proper syntax for embedding DLookup inside DSum 1
DSUM criteria 3
Dsum() in Group Footer 1
Dsum Help 0
DSum between dates 1
DSUM Question 2

Top