Hello all,
I am fairly new to Access database design and looking for some guidance.
I have designed a form that is for testing specification requirements. For example...
I have a form that is asking for the following:
Strength 1
Strength 2
Strength 3
Strength 4
AVG Strength (calculated field based on Strength 1-4)
Which is all working as I want.
What I am trying to do
I want access to look at the AVG Strength field against another table for a specification for a particular Strength. If the AVG Strength passed the required criteria, I would like to display a PASS label on the form. If it fails the criteria check, I would like to display a FAILED label on the form.
So, I guess there are two things I am look for help?
1.) How to check against my specifications table and see if the AVG Strength passes or fails?
2.) How to get a label to display depending on the outcome. (PASS / FAILED)
The form is tided into a main table with lots of other columns which are not relevant at this time, the fields that are relevant would be:
MAIN Table
TestID
Test Code
Strength 1
Strength 2
Strength 3
Strength 4
AVG Strength (calculated field)
SpecID (linked via relationships)
SPECIFICATIONS Table
SpecID (linked via relationships)
TestCode
Strength Specification
So my idea if this....
I enter my 4 strength values, access calculates the average of the 4 strengths tested. Once the average is calculated, I want access to check the specifications table based on the TestCode. If the TestCode entered on the form matches that of be in the Specifications table, look at the strength specification and whether it passes or fails display a corresponding label on the form. I would assume we would be using something like a vLookup or dLookup here? Just not sure where to start here....?
How would I go about doing this? I am very new to the VBA programming side and not sure which route to take? Some guidance would be great. Thank you in advance.