Access Query Compare three field in same record

[ramirezx@ddmfg.com]

Hi,



I'm trying to create a query that has part # field and three columns with values. I want to create a fourth column that will say match or no match, no match if all three columns do not equal the same.

Part #	Column_1_Total	Column_2_Total	Column_3_Total	Match/No Match
004	0	2450	0	No Match
005	0	0	16	No Match
010	9300	9300	9300	Match
011	0	0	35	Match
012	4870	4870	4870	Match

I want a query that will check all three columns to make sure they all match?

Thanks,
Xavier

[pbaldy]

I'd probably adapt this to test for equality:

https://support.microsoft.com/en-us/...elds-of-record

But it may be simple enough to have something like:

IIf(Column_1_Total = Column_2_Total AND Column_1_Total = Column_3_Total, "Match", "No Match")

[ramirezx@ddmfg.com]

Awesome, that did the trick, thanks so much!

Xavier

[pbaldy]

Happy to help!