DSum Function with 2 Criteria

[JithuAccess]

Hello Guys,

I was trying to find the Total count of Records based on 2 criteria in my Report. This is my Code:

=DSum("[strTransmission]","[Table1]","strTransmission='A:B' And [datPayment Date] Between #2020-04-01# And #2020-04-30#")

But I am getting #Error

Could you please let me know how to fix this?

Thanks

 

[theDBguy]

Is strTransmission the name of your field, and it would literally have A:B as a value in it?

 

[JithuAccess]

Is strTransmission the name of your field, and it would literally have A:B as a value in it?

Yes [strTransmission] is the name of my Field and there are 2 Records A:B between 2020-04-01 and 2020-04-30.

Thanks

 

[plog]

Strings (strTransmission) don't lend themselves to being summed. Numbers usually fill that role.

 

[JithuAccess]

Strings (strTransmission) don't lend themselves to being summed. Numbers usually fill that role.

I have changed my Code like:

=DCount("[strTransmission]","[Table1]","[strTransmission]='A:B' And [datPayment Date] Between '#2020-04-01#' And '#2020-04-30#'")

But still getting same #Error in my Report.

Thanks

 

[Minty]

You have put ' ' delimiter around your dates. The dates delimiters are the # # .

=DCount("strTransmission","Table1","[strTransmission]='A:B' And [datPayment Date] Between #2020-04-01# And #2020-04-30#")

N
Note that the [ ] around the table name and field name are unnecessary when there aren't spaces in the names and they aren't reserved words.

Another bonus of a good naming convention

 

[JithuAccess]

You have put ' ' delimiter around your dates. The dates delimiters are the # # .

=DCount("strTransmission","Table1","[strTransmission]='A:B' And [datPayment Date] Between #2020-04-01# And #2020-04-30#")

N
Note that the [ ] around the table name and field name are unnecessary when there aren't spaces in the names and they aren't reserved words.

Another bonus of a good naming convention

Many Thanks. This worked Perfect