Struggling with Dsum

[tucker61]

I need to add additional criteria to my Code below

=Nz(DSum("Qty","tblunpickable_data", "Option='" & [tbOption] & "'  "),"")

the additional field i need to add is Status <> "PK" but when i have amended and i now get the #Name? error.

=DSum("Qty","tblunpickable_data","option='" & [tbOption] & "' And [Status]='" & [PK] & "'")

any help appreciated.

 

[isladogs]

I need to add additional criteria to my Code below

=Nz(DSum("Qty","tblunpickable_data", "Option='" & [tbOption] & "'  "),"")

the additional field i need to add is Status <> "PK" but when i have amended and i now get the #Name? error.

=DSum("Qty","tblunpickable_data","option='" & [tbOption] & "' And [Status]='" & [PK] & "'")

any help appreciated.

Equal to or not equal to ....?

If you want Status <> "PK" then

=DSum("Qty","tblunpickable_data","option='" & [tbOption] & "' And [Status]<>'PK'")

For Status = PK then

=DSum("Qty","tblunpickable_data","option='" & [tbOption] & "' And [Status]='PK'")

 

[Ranman256]

if you are running DSUM in a form:
the variable must look at the name of the text box (or combo or other control)
NOT the field name. Brackets are for queries to determine field names...
[Status], or [tbOption]
Do not use brackets for control names.

=DSum("Qty","tblunpickable_data","option='" & me.txtOption & "' And [Status]='" & me.txtPK & "'")

 

[tucker61]

Equal to or not equal to ....?

If you want Status <> "PK" then

=DSum("Qty","tblunpickable_data","option='" & [tbOption] & "' And [Status]<>'PK'")

For Status = PK then

=DSum("Qty","tblunpickable_data","option='" & [tbOption] & "' And [Status]='PK'")

Thanks mate this worked.. I always struggle with the apostrophe and the speech marks..