||A related question:
I have a field of addresses -- let's call it [ADDRESS] -- whose 16 last letters/digits must be removed.
12345 Oak Ln : XXXXXXXXXXXXXXXX
98765 Castle St : XXXXXXXXXXXXXXXX
645 Happy People Rd : XXXXXXXXXXXXXXXXX
I want to cut out those last 18 letters/digits, beginning at the colon ":".
I've used the InStr function to determine where the colon ":" begins on each field. I've created a new field -- let's call it [InStr] -- containing the numeric value of where the colon begins in every record.
I want to calculate a new field -- let's call it [ADDRESS] -- with only the addresses, without everything from the colon onwards. I was hoping that I could simply use the following VBA function:
Left ([ADDRESS], [InStr] -1 )
But, as I'm sure you already know, it didn't work.
Can anybody help? Thanks in advance!!!