Valadation Rule

[esskaykay]

I have a table with an ASSESS field limited to “Y” or “N”. I would like a memo to popup if some tries to enter an “N” into the ASSESS field (from a form) if the sum of a few other fields is > 0. I’m assuming I need a validation rule but can’t seem to get it working.

Example:
When entering an N into field ASSESS, if “([W1] + [W2] + [L1] + [L2]) > 0” a message would popup displaying stating “Assessable items exist”

Thanks,
SKK

 

[ChrisO]

G’day SKK.

Just being curious as to why the user would be entering Yes/No if a calculation could determine if No would be incorrect?

Regards,
Chris.

 

[cpremo]

I agree. If you have a "Rule" that says if X=KKK and Y=ppp and Z=uuu then W=0 why not just use code to enter a "0" for W and lock the field? That way you can't have an error in your data.

PS This would be done on the form via VBA code.

 

[esskaykay]

Actually I tried to simplify the question. What we’re doing is tracking sidewalk repair notices. We have numerous tables, queries, forms, reports, etc. in our database. Our inspector inputs data from the field into his laptop which in turn is uploaded nightly to the master file on our server. We track both assessable and non-assessable items as the contractor must be paid for all work performed not just the work to be assessed against the abutting property. Thus, we track the area of assessable and non-assessable sidewalk work separately. However, there are a few instances (albeit seldom) where data is enter as assessable even though it will actually not be included in the assessable items (too complicated to explain here). Assessable records are controlled by a “Y/N” field called ASSESS. What I want is if any of the assessable fields are populated and the inspector sets the ASSESS field to “N”, I would like a popup box (or something) to warn him of his potential erroneous entry.

Thanks,
SKK