muralidaran
New member
- Local time
- Today, 07:57
- Joined
- Jan 18, 2012
- Messages
- 7
Hi Everyone...
Good day,
I have the below given Dcount code with multiple criteria and I wanted to add 1 more condition which I couldn't solve myself.
Kindly help me to fix this.
The Current Code
The Changed code.
Please note that this post is already posted in Utter Access but I am not allowed to post the link here due to limitation.
Thanks
Best Regards
M.
Good day,
I have the below given Dcount code with multiple criteria and I wanted to add 1 more condition which I couldn't solve myself.
Kindly help me to fix this.
The Current Code
Code:
CountMsg = DCount("*", "[F_Tbl_Msg]", "[ToUserID]='" & [TempVars]![TempUser] & "' And IsNull(DateReceived)")
The Changed code.
Code:
CountMsg = DCount("*", "[F_Tbl_Msg]", "[ToUserID]='" & [TempVars]![TempUser] & "' Or "[ToUserID]='" & All & "' And IsNull(DateReceived)")
Please note that this post is already posted in Utter Access but I am not allowed to post the link here due to limitation.
Thanks
Best Regards
M.