Comparing values in Access

[kd2017]

I had a chance to briefly test my code from post #2. It appears to work as you requested *if* you had nulls instead of -1... dare I suggest running an update query to change your -1's to nulls? Maybe a bad idea since I have no clue what this even is or what the rest of your app looks like... I'll bow out now though, Ajax is the vip!

[mikesal57]

Sorry gentlemen....

A little off....

CODE

result: Abs([nPP1SHF] Is Not Null And Nz([nPP1SHF])<=Nz([nPP2SHF],[nPP1SHF]) And Nz([nPP1SHF])<=Nz([nPP3SHF],[nPP1SHF]) And Nz([nPP1SHF])<=Nz([nPP4SHF],[nPP1SHF]) And Nz([nPP1SHF])<=Nz([nPP5SHF],[nPP1SHF]) And Nz([nPP1SHF])<=Nz([nPP6SHF],[nPP1SHF]) And Nz([nPP1SHF])<=Nz([nPP7SHF],[nPP1SHF]) And Nz([nPP1SHF])<=Nz([nPP8SHF],[nPP1SHF]) And Nz([nPP1SHF])<=Nz([nPP9SHF],[nPP1SHF]) And Nz([nPP1SHF])<=Nz([nPP0SHF],[nPP1SHF]) And (Nz([nPP2SHF])+Nz([nPP3SHF])+Nz([nPP4SHF])+Nz([nPP5SHF])+Nz([nPP6SHF])+Nz([nPP7SHF])+Nz([nPP8SHF])+Nz([nPP9SHF])+Nz([nPP0SHF])<>0



Both these circled ....the 1 should be zero and the zero should be 1

[CJ_London]

A little off....

do you not read your posts? - see #13 and #9

[mikesal57]

My fault, doing too much....

It worked ....

thank you guys