I'm nearly there with:
SELECT Clients.[Client Code], Clients.[Client Name], Clients.[Trading As Name], Clients.[Client Type],
IIf((Now()>DateValue([Year End (dd/mm)])),DateValue([Year End (dd/mm)]),(DateValue([Year End (dd/mm)])-365)) AS [Year end],
[Records Received].[Year End Date]
Although...