Simple Dsum on a report

[Robert.Bailey]

Hello,
New to using reports. I am not understanding how the Dsum works, or better I can use it. I have a report that counts a different number of units per Record. I just want to total the units shown on the report. The Report is currently base on a query that shows me all units ran by a line in a day. I just need to total the units can't seem to get it to work.

Thanks

 

[Alansidman]

Here's a link on DSUM

http://www.techonthenet.com/access/functions/domain/dsum.php

 

[Robert.Bailey]

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.

 

[Alansidman]

I think you need to set the criteria "SomeField = Date()". I think that you will also have to surround the Date() with #.

Read on here

http://www.access-programmers.co.uk/forums/showthread.php?t=219767

 

[Pat Hartman]

If you are summing data that is included in the report, you don't use a domain function.

=Sum(yourfield)

Keep in mind that "yourfield" can be the name of a field in the recordSource or an expression referring to several fields in the RecordSource. It CANNOT be the name of a control. So if the ControlSource of the control you want to sum is
=FldA + FldB
and the name of the control is MyControl, the ControlSource of the total field will be:
=Sum(FldA + FldB)
It cannot be
=Sum(MyControl)