I am trying to find and reconcile the differences between our inventory table (fpd26a) and a pipe delimited textfile dumped from a batch scanner. I imported the fpd26 data to an excel sheet and the delimited textfile to another sheet in the same workbook. I was trying to get Crystal to compare the item numbers and return the item numbers that are in the table that the textfile does not have or vice versa, but the day is getting late and my brain is not seeing the path.

What is so simple about this that I am not getting it?

TIA to all,
Matthew