Dsum returns null with date criteria

Question

I'm using Dsum with a date criteria in a textbox in form1 where tdate in table [T] is before the text box [tar]

=DSum("[T].[total]","[T]","[T].[tdate]="&<[forms]![form1]![tar])

but it returns null in the textbox.. I tried to add "#" before and after tar .. and tried to put quotation before and after the criteria but nothing worked .. can I know whats wrong with it ?

thank you 

Answer 1

What about

=DSum("[T].[total]","[T]","[T].[tdate]<" & Forms![form1]![tar])

Don't forget :

• dates need to be surrounded by #
• string need to be surrounded by '

So, in fact, I'd probably be something more like

=DSum("[T].[total]","[T]","[T].[tdate]<" & Format(Forms![form1]![tar], "\#mm\/dd\/yyyy\#"))

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

thank you very much Daniel Pineault its working now :D