Hello,
I have an Excel formula that I haven't been able to mimic in Access as a query and I'm not sure how to even start.
The Excel Formula: =IF(COUNTIF($A$2:$A$10,$A2)<>COUNTIFS($A$2:$A$10,$ A2,$B$2:$B$10,B2),"Yes","")
This formula is used in the following Context:
SBSB_ID
PCP In?
Formula Compare
903490878 N/A
903490494 Yes
903490502 Yes Yes
903490521 N/A
903490509 N/A
903490509 N/A
905409331 N/A
903490502 No Yes
905277856 N/A
This formula returns a "Yes" if any of the same IDs have different "PCP In?" values.
Given the same table in Access, is there an update query that can be used to mimic this formula's return?
Any help is greatly appreciated!