I don't know how I've managed to do it, but I've messed up my SELECT query which is used by an append query.
I have two queries. The first is a simple query that contains the Pk from my main table [prospects] and a split_code query to take the first one or two digits of a postcode.
code...