Re: [MSAccessProfessionals] Stripping out a zipcode

This is what I ended up with and it works:

Left(Mid(Nz([JobAddressLine3],""),InstrRev(Nz([JobAddressLine3],"")," ")+1),5)

 

This assumes that everything after the last space in [JobAddressLine3] is the zip code. If JobAddressLine3 is null, this expression will return an empty string.

Thanks.