theinviter
Registered User.
- Local time
- Today, 13:36
- Joined
- Aug 14, 2014
- Messages
- 240
Dear guys,
Need help please with attached file ,
i have tried Dsum but did not get any value. jus getting " #Name?"
I need the form "Data_list" where
Field " Price1" Dlookup the ([Buy Rate], from Table " Rate_report" where "item code" match with " New Code"
Text153 = DSum([Quantity]," [MRN_Report] ","[Item Code
] =" & [New Code] & "'") + need add triple criteria between {date from and to} and [ Location (Clinic) Code ] match with "Location code" .
i have attached the file. so if you can please modify and correct me.
tanks
Need help please with attached file ,
i have tried Dsum but did not get any value. jus getting " #Name?"
I need the form "Data_list" where
Field " Price1" Dlookup the ([Buy Rate], from Table " Rate_report" where "item code" match with " New Code"
Text153 = DSum([Quantity]," [MRN_Report] ","[Item Code
] =" & [New Code] & "'") + need add triple criteria between {date from and to} and [ Location (Clinic) Code ] match with "Location code" .
i have attached the file. so if you can please modify and correct me.
tanks