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

Becky

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

Similar Threads

Count Based on Comparison with Two Fields 2
Busted IIf function 3
IIf statement in query, Null value change to "0" 2
Can I use OR in the THEN or ELSE portion of an IIF statement? 2
IIf in a report based on select query -- problem w/parameters 2
Suppressing Parameter Query Prompt 1
Unwanted Parameter Prompt 4
Criteria for an Iif statement in a query 2

Top