Dcount With Multiple Criteria

M

muralidaran

New member

Local time

Today, 21:22

Joined

Jan 18, 2012

Messages

7

• Feb 24, 2016

• #1

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

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.

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Tomorrow, 02:22

Joined

May 7, 2009

Messages

20,339

• Feb 24, 2016

• #2

CountMsg = DCount("*", "[F_Tbl_Msg]", "[ToUserID]= ('" & [TempVars]![TempUser] & "' Or [ToUserID]='All') And IsNull(DateReceived)")

 

M

muralidaran

New member

Local time

Today, 21:22

Joined

Jan 18, 2012

Messages

7

• Feb 24, 2016

• #3

Hi Mr. arnelgp
Thanks for your time and suggestion, I got an Run-Time error '3464', Data type mismatch in criteria expression.

The field ToUserID is a text field.

Please advise..

 

Mile-O

Back once again...

Local time

Today, 19:22

Joined

Dec 10, 2002

Messages

11,316

• Feb 24, 2016

• #4

I would have thought IsNull(DateReceived) would be better written as DateReceived Is Null in this context.

Anyway,

Code:

CountMsg = DCount("*", "[F_Tbl_Msg]", "([ToUserID]= """ & [TempVars]![TempUser] & """ Or [ToUserID] = ""All"") And [DateReceived] Is Null")

Personally, I'd do away with all underscores, hyphens, whatever in your field/table/object names as it's universal pain when working in Access.

 

M

muralidaran

New member

Local time

Today, 21:22

Joined

Jan 18, 2012

Messages

7

• Feb 24, 2016

• #5

Thanks Mr. Mile-O
That worked well.

Regards
M