I'm not sure how to do this, and I can't seem to figure it out by reading instructions or the help guides in Access 2007, so any help is GREATLY appreciated. I'm sure it's obvious once you know how to do it.
In one table, I have ID#s (in column 1) that are labeled as Case or Control (in...