theinviter
Registered User.
- Local time
- Yesterday, 20:36
- Joined
- Aug 14, 2014
- Messages
- 240
..
..
..
..
..
.
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
..
..
..
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
.
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
.
..
.
.
..
.
..
..
...
.
..
..
..
..
..
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
.
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
Dear guys;
need you help in the code below,
wanna get the data between 01/01/2022 to 12/31/2022
how to modify the code
Nz(DSum("[Link value]","[MRN]","[Item Code] ='" & [Item Code1] & "'AND [Location - Clinics Code] =" & [Location_Code] & " AND [Date_] BETWEEN # 1/1/2022#AND #12/31/2022#),0)
got error with above code
thanks
..
..
..
..
.
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
..
..
..
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
.
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
.
..
.
.
..
.
..
..
...
.
..
..
..
..
..
..
..
..
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
.
..
..
.
.
..
.
..
..
...
.
..
..
..
..
..
Dear guys;
need you help in the code below,
wanna get the data between 01/01/2022 to 12/31/2022
how to modify the code
Nz(DSum("[Link value]","[MRN]","[Item Code] ='" & [Item Code1] & "'AND [Location - Clinics Code] =" & [Location_Code] & " AND [Date_] BETWEEN # 1/1/2022#AND #12/31/2022#),0)
got error with above code
thanks
Last edited by a moderator: