Iif and blank/Is null

[gmazza76]

Good afternoon,

I know its a simple query but I have been going round in circles

I want to create a formula as below to count the [Category] and [Assigned To] show me how many aren't aligned (ie is a blank in [Assigned To]

This is what I have so far and know I can use IsNull, but I am having an issue on how to write it.

New: Sum(IIf([table1].[Cat1]="BM" And [table1].[Name]="",1,0))

thanks in advance
Gavin

 

[welshgasman]

IsNull Function - Microsoft Support

Syntax: IsNull(expression)

support.microsoft.com

NB: There is a difference between Null and a ZLS.

 

[Joe4]

Access also has an NZ function which can be helpful at times, depending on your data and goal.

Nz Function - Microsoft Support

Syntax: Nz(variant [, valueifnull ] )

support.microsoft.com