I was having an issue with DSum Function. Some users advised to use following expression to arrive at desired figure, but it has still not worked.
=DSum("[Total Input]","Production","[End of Production] = #" & DateValue([Forms]![MIS]![Text0]) & "#")
I have done a slight modification in the expression (as given below). Actually, I have removed DateValue & also used Form's, Form Name and Field in one Square bracket & now it is perfectly working.
=DSum("[TInput]","Production1","[End of Production]= #" & [Forms!MIS!Text0] & " # ")
Similar to this, I have an another issue. Now, inplace of a particular date, I want to get the value (Total Input) from the same table [Production] but pertaining to the month of Entered Date [Text0]. I have tried various expressions like Month(Text0), Format(Text0,"mmm") but not getting desired output.
I shall be thankful if anybody help me for the same.