Street Nos

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have used the following Update query to transfer street nos from an old
addess field to a new street no field:

"Left([Street Name], In Str([Street Name], " ") -1)

When I run the query, certain street nos are transferred and not others. I
have made sure that the first lot of characters are correct. Do spaces have
an influence on this EG: 56 Smith St Village as opposed to 56 Smith St.
Any help would be appreciated
 
I have used the following Update query to transfer street nos from an old
addess field to a new street no field:

"Left([Street Name], In Str([Street Name], " ") -1)

When I run the query, certain street nos are transferred and not others. I
have made sure that the first lot of characters are correct. Do spaces have
an influence on this EG: 56 Smith St Village as opposed to 56 Smith St.
Any help would be appreciated
Click to expand...

Your expression would return just the 56 from either example.

If that's not what you want, what exactly is it you do want, using the
above, or additional, examples.
 
Back
Top