hi Lynn

this is great, thanks for the outer join used also as making more sense to me now 🙂

would it be difficult if a value was to be output rather than a yes or no to themnot matching using the case statement? this would give me the actual variance between actual and expected also and kill 2 birds with one stone for me?