Dsum

[doddiah]

I have a from which has a sub Form in it which uses a query of a table which is filtered, In the main form I want a sum of the data in the subform for a particular field if TRUE.


In the main form I have a text field with the Syntax =DSum("[Cost]","RepairInformation","[Labour] =.True."), but this returns an error, I have no issues for the total cost for with I have a Text Box in the subform which returns the Total cost in the main form.

What are my options to have a conditional sum for a particular condition.

Thanks


Regards

[ranman256]

Remove the periods in the Dsum. .true.
the TRUE goes outside the quotes.
"labor=" & true
or
Build a query that sums only TRUE values. Have a subForm for this qry.

[pbaldy]

Why does the True need to go outside the quotes? Fixed values like that I leave inside.

[ranman256]

I guess it can work Inside as well. True is true.

[doddiah]

Thanks,

I am a novice, but am able to handle other stuff but DSUM and DCount never work for me. Would it be better I used a Dynaset of the query of the sub-from and if so in that case what will be the syntax to make use of the record source of the sub-form

[pbaldy]

Did you try taking the periods out?

=DSum("[Cost]","RepairInformation","[Labour] =True")