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
amanitali2010 0 Newbie Poster
adam_k 239 Master Poster
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. 1 for the failed records and 1 for the success ones. You can put them in a macro and run it with a button click or on form load with some VBA.
BitBlt 452 Practically a Master Poster Featured Poster
Access does have a version of the "IIF" statement that you can use in place of CASE. It's not pretty when you have to nest them, but it should do the trick.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.