hi dear i i have two columns in an access table, first column is of percentage and second is of result . i want that result should be automatically calculated as if the percentage is les than 33 then ruselt fail and if percentage is greater than 33 then result should be passed plz reply
Jump to Post
If I remember correctly Access doesn't support case (which would make this a walk in the park).
Do you want to update the table, show the calculated column on a form / report or what?
If you just want to update the table you can create 2 update queries. …
All 2 Replies
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.