How to create a validation rule to make sure that one field is not greater than another field.

[NewbieNinja]

Hello, everyone!

Please forgive my noobness I am a college student who has just completed Introduction to MS Access course at my local community college. I was asked by a friend of mine to make a small Access DB that would store client information. In the process of creating this DB, I ran into a small problem. What I need is to create a validation rule so that the Account Balance field can only be subtracted if the Payment field is equal to or less than the Account Balance field. I have tried a bunch of different steps but I keep getting error messages. Any suggestions?

[Micron]

You should not be storing calculations in tables. Where you away that day, or are they not teaching this most basic precept?
In a case like this, aggregate (math) functions should be performed on the sum of all values in a field vs the sum of another field, and this should be done on a form. You would test if txtBalance exceeds txtPayment before processing the payment. Not sure why you'd want this rule anyway. Is it not possible that someone would accidentally make a payment twice or a payment that exceeds the balance? Surely I am not the only one who has ever done that.

[NewbieNinja]

I was technically never absent. The course was online and all the homework we did was out of a book. The professor wasn't that great either. Never answering emails and tests that had nothing to do with the material we covered from week to week. But... I am rambling about my issues. This is AccessForums.net, not Dr. Phil. Thanks for the information.

[Micron]

Well, we will try our best here to be supplemental instructors! Post back if you need more information.