DSum ! I jumped the Gun

[libraccess]

my earlier post where I had a problem totalling fields on a report I thought the DSum had fixed this


using the =DSum("[SourceVol]","[tblDelMain]") in an unbound control on the report sums all [SourceVol] in the DB
My Report is opened by using two unbound cbo =[Forms]![frmReports]![txtStartDate] and =[Forms]![frmReports]![txtEndDate] via VBAI'm picking I need to either include the DSum in my VBA or in the query for the report to Sum only those records in the report but I cannot get them to work
help again please

[pbaldy]

How about this in the report footer

=Sum(SourceVol)

[libraccess]

That was my first attempt. The main form has SourceVol as a control with one entry the subform has SupplyVol as control with multiple entries(typ. 1-4 entries). So the report adds one sourcevol amnt for every supplyvol entry
Explanation: SourceVol is a pick up of goods and SupplyVolis thedelivery of goods
So Sum(SourceVol) gives a totally inflatedno. but DSum gives the correct total for all records not the screened records. I am using an Allen Brownecode for screening start enddate and cbo record. Have tried to write dsum with criteria into the vba and also into the query but withno joy
Thanks

[pbaldy]

Then you can add a criteria to your DSum:

DLookup Usage Samples

[libraccess]

This is what I came up with but it returns an #error
=DSum("[SourceVol]","tblMain","[DelDate] Between #" & [Forms]![frmReports]![txtStartDate] & "# And #" & [Forms]![frmReports]![txtEndDate] & "#")
This I entered into the control source of an unbound control in the Report Footer
I have added a zip that has had some notes highlighted if some could see what is happening here I would be grateful
Thanks

Attachment 6608

[pbaldy]

Have you tried with the correct table name?

[libraccess]

ooPS!
talk about the forest from the trees

[pbaldy]

Brain cramps...we all get them.

[libraccess]

I used to do building (houses not DBs) Golden rule, if a plan, when a plan is superseded you file the old one away where no one can get to it. So when you change a tbl name I guess you get rid of any old notes
Thanks again