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


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?
 
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,508
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top