I currently have two tables; Total & Out Proccessed Personnel
I have created a macro in design view which starts by setting a temporary varible via user input. It requests a SSN from the users and saves it under the name SSN.
The macro then executes three queries, using the tempVar as...