Hi David, Thank you so much for the reply.  The ISNULL in the SQL query was just the thing and it all works a treat now.  Thank you so much...

Hi David, sorry for the delay but have been battling with this report again for days.

I believe that I am already doing what you have suggested however I am still...

• This reply was modified 5 years, 11 months ago by  caroline.allen. Reason: referenced post is above and not below this post

Hi,

I have a slightly amended version of Audrey's code from above which works well for the following scenarios:

• if I want to remove an entry from one of the address...

Hi Audrey, Thank you so much for the prompt reply.  It took me a while to get my head around where to use the code and how best to put...