Like many people I receive an unmanageable amount of email each day. Many days I get through only around 1⁄3 of the email I receive. However, the role I am in professionally requires me to retain a large proportion of correspondence. Some because it relates to ongoing projects, other because of security, audit or compliance reasons. In addition, I work across many projects. It isn’t unusual for me to be involved in two dozen projects at any one time on top of my day-to-day management work.
I need to find a load of addresses by proximity to a postcode. I have the addresses in a Microsoft Access database. Download Paul Jenkins’s UK Postcode csv and import into Access as a table Create a query on your own table adding the following calculated field: PCregion: Trim( Left( [My Table]![Postcode], InStr( [My Table]![Postcode], ” ” ) ) ) Create a second query that joins the above query to the imported postcode table.