Street Nos

[Roger Bell]

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

 

[fredg]

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

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.