Dsum Function In A Report

[FontanaS]

I have the following code:
=DSum("[ObligationAmount]","Tbl_Current_Year_Information","[FiscalYear]= '" & [Curr_Fy] & "'&quot

The problem is that [Curr_Fy] shouldnot have brackets around it becasue it is a variable that I created to hold the current fiscal year.

Whenever I try to take the brackets off, it puts them on again. Can you have user defined variables in the dsum function?

 

[galar]

Been there, done it... with no success.
You should create a function that will return the value of this variable:
public functon get_Curr_Fy()
get_Curr_Fy = Curr_Fy
end function

and then use it in your Dsum sentense like this:
=DSum("[ObligationAmount]","Tbl_Current_Year_Information","[FiscalYear]= '" & get_Curr_Fy() & "'&quot

That solved the problem for me