I need to find a load of addresses by proximity to a postcode. I have the addresses in a Microsoft Access database. 1. Download Paul Jenkinsâ€™s UK Postcode csv and import into Access as a table 2. Create a query on your own table adding the following calculated field: <pre>PCregion: Trim( Left( [My Table]![Postcode], InStr( [My Table]![Postcode], ” ” ) ) )</pre> Create a second query that joins the above query to the imported postcode table.