Here is what I have tried. Now i am not getting an error, The text box is just blank.
=DSum("[UnitsonPallet]","Report Query","Date()")
=DSum("[UnitsonPallet]","Report Query")
I just want to Total the UnitsonPallet. The Report is based on Report Query.