theinviter
Registered User.
- Local time
- Today, 04:22
- Joined
- Aug 14, 2014
- Messages
- 237
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
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