Hi,

Thanks for your reply, Im not a complete newbie as I have an Access background and so I do understand joins and relationships. What I struggle with is working out...

Ah ok I think I understand, the picture below shows Table 1 with Null values but as you can see they are the values in Table 2 - this is...

Hi John thanks for the reply. So Im guessing COALESCE allows you to define a value for 2 Fields which are the same or have I completely missed the point?...