I was writing it up the 2nd way initially namliam, but I like the 1st way a little better.
Now I just need to do two more things to complete this one:
1. Formulate the results into graphs for reporting - hopefully I can create a PivotChart or something referring to the above fields.
2. Start...
Thanks a tonne for the quick responses guys. I feel like a bit of an idiot just quietly! I figured out the rudamentary way of doing it about 5 min ago as I was packing up to go home - you've both expanded on that for me to make the coding a little smoother.
That'll teach me for having only...
G'day!
I've been researching all day, and have finally given up. I'm an Access n00b, but can understand low-level coding when reading it.
What I'm looking to do is calculate the success rate (%) of compliance rates with Quality Control paperwork. Essentially, each record has 12 "check box"...