How to write the Dsum "WhereCondition" on Subform 1

[rccline]

I would like to show the total of my subform on the main form.

I have tried to create a textbox on my subform using =Sum([WI])
I have seen and read examples, but in my case, this formula only returns the message: #error


I tried to use Dsum that I read in thread702-1778486.

The solution calls for an optional WhereCondition. Duane Hookem wrote:

=DSum("Amount","Your table or query name","Optional WhereCondition")

The following returns the sum of the WI field in the entire database.
DSum("WI","myQuery","InstrumentID"

These return the error #Name?
DSum("WI","myQuery","InstrumentID","Me.InstrumentID")
DSum("wi","myQuery","InstrumentID=" & [Me].[InstrumentID])


I do not know how to write the Optional WhereCondition.
Guessing how to write the optional WhereCondition isn't working for me.

I want to sum the WI for the current record only.
Grateful for help with this.

Thank you.

Robert

 

[dhookom]

Try this assuming InstrumentID is numeric and myQuery is the recordsource of the subform:

=DSum("wi","myQuery","InstrumentID=" & [InstrumentID])

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[rccline]

Thank you very much Duane! That worked like a charm.

Robert