Furriniture

Spent most of the day in the office but E called me out to the garden having spotted the curious fungi growing on the end of the carved 'coffee table'.

--
Spent a while with a problem to which the answer was: If(IsNull ([Prefix1]),[FirstName1],[Prefix1]+" "+Left$([FirstName1],1)+".")+" "+IIf(IsNull([Firstname2]),[Surname1],IIf(IsNull([Surname2]), "and "+IIf(IsNull([Prefix2]),[Firstname2],[Prefix2]+" "+Left$([Firstname2],1)+".")+" "+[Surname1], [Surname1]+" and "+IIf(IsNull([Prefix2]),[Firstname2],[Prefix2]+" "+Left$([Firstname2],1)+".")+" "+[Surname2]))

(Filed here in case I ever need it again) :o)