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
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