ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count

M

MOMO2019

Joined
May 31, 2019
Messages
1
Reaction score
0
I have two columns set to count. I am trying to add a third with an IIF statement that looks at the two columns and returns if they match or not.

Its working however when I run the query is prompts me to add parameter value. Trying to understand how I get the syntax to work so it stops prompting this?
 
Welcome to the forum :)

If I'm understanding correctly, you can use SUMPRODUCT like so:

=SUMPRODUCT(--(range1=range2))

The double minus just gets the formula to treat the TRUE / FALSE as numbers. Give it a try and let me know if it works for you.
 
Back
Top