Solved Need Help Ms access with Dsum

[theinviter]

Dear Guys
need help with D sum function.

I have a query and added extra field where i want to get the sum based on 2 text criteria (item code and company name)
i tried this :
DSum("[Link Value]","MRN","[Item Code]like""" & [Forms]![MRN Query]![Item_Code] & """ AND [Account Name] like """ & [Forms]![MRN Query]![Account_Name] & """")
but did get any result just got this number "4502" in all column.

so any help

 

[June7]

Instead of saving ItemCode and Clinic into MRN should be saving ID from Combine.

Strongly advise not to use spaces nor punctuation/special characters in naming convention.

Why are you including Combine in form RecordSource?

LIKE without wildcard can just be = sign.

Can use apostrophe instead of doubled quote marks.

Can't use Me. in textbox expressions. Me. is used only in VBA.

=DSum("[Link Value]","MRN","[Item Code]='" & [Item_Code] & "' AND [Account Name] = '" & [Account_Name] & "'")

In query:

Expr1: DSum("[Link Value]","MRN","[Item Code]='" & [MRN].[Item Code] & "' AND [Account Name] like '" & [MRN].[Account Name] & "'")

 

[theinviter]

Instead of saving ItemCode and Clinic into MRN should be saving ID from Combine.

Strongly advise not to use spaces nor punctuation/special characters in naming convention.

Why are you including Combine in form RecordSource?

LIKE without wildcard can just be = sign.

Can use apostrophe instead of doubled quote marks.

Can't use Me. in textbox expressions. Me. is used only in VBA.

=DSum("[Link Value]","MRN","[Item Code]='" & [Item_Code] & "' AND [Account Name] = '" & [Account_Name] & "'")

In query:

Expr1: DSum("[Link Value]","MRN","[Item Code]='" & [MRN].[Item Code] & "' AND [Account Name] like '" & [MRN].[Account Name] & "'")

thank for help.
can you please do the change in attached file, i tried but could not solve it.

 

[June7]

Simple change. Open query and copy/paste my suggested expression. Same for textbox on form.

 

[theinviter]

solved thank you

 

[June7]

Actually, I have used LIKE with numbers to solve an OP's issue.https://www.accessforums.net/showthread.php?t=85033