Thanks to all. My days of heavy duty Access programming are well behind me. However, I still like mental challenges and I saw an opportunity to assist my high school classmates to execute an online 60th year reunion. I decided to just add an OMG field to the Address table to display on the report. I had to create and execute 3 Update Queries to populate the field, one for each of the 3 values that are allowed to appear in it.
The 3 cases were:
1. Insert an "M" if "Missing" = "T" and "Gone" = "F"
2. Insert a "G" if "Gone" = "T" and "Missing" = "F"
3. Insert an "O" if neither case applies, since "Gone" and "Missing" cannot be "T" at the same time.
I also set the default value for new "OMG" fields to be "O". On the data entry form I wrote some code for the After Update event on both the "Gone"
and "Missing" checkboxes to only allow the 3 cases above to appear and to place the correct letter into the "OMG" field
Thanks again to all. We all could use some "mental" stimulation these days. Stay well.