I'm very new to Access. I would like to create a database that allows users to track testing progress. This means there will be a table of tests - each with a specification like low < result < high, result > low, result > high (could also be <= and >=) described in fields for each test table record. The user should be able to enter the result in another field and have the database determine whether the result meets the spec and have pass or fail recorded in another table.
Is this something that can be done without writing VBA code or can I accomplish this with just the standard Access GUI functions?
Thanks