Here is a grab from the table. How can two of those work, and the other two not work?
AGGGGGHHHH!!!!! The field was a NUMBER field, and I had a mix of numbers and text. The numbers were showing up, but not the text. Asking the questions popped it into my head I guess. Thanks anyway!