Removing last two characters from a field (Post Code) 1

[Deano1976]

MS Access 95

I would like to know how I can remove the last two characters from a field using a query.

The field is a post code field which sometimes has the post code entered with a space and sometimes without.

e.g.

NR11 8DD
NR118DD

For both of these examples I only want to remove the last two characters - DD and be left with NR11. I pressume I can use the rtrim function to get rid of any spaces after that.

 

[Golom]

Left([PostCode], Len([PostCode])-2)

except that, with your examples you will be left with
[tt]
NR11 8DD ---> NR11 8
NR118DD ---> NR118
[/tt]