H
hcj
Hi Landen,
If the street name always occurs after the first space,
you could use this calculated field in a query to break
out and sort on the street name. If there are variations
that would break this rule (e.g. 123 N. Main St.), then
you'll have to play with the idea to get at the string
following the 2nd space, etc.
StreetName: Right([address],Len([address])-InStr
([address]," "))
Just an idea.
example "325 Providence Road") and have it sort by the
street name instead of the street number. I don't have a
way to break the street numbers out as a seperate field
because of the front end app. I thought about converting
each character from left to right to ASCII and then
looking for the first alphabetic character in the range of
ASCII characters and using that to sort by, but I can't
figure out how to do it. Does anyone have any other
suggestions? Thanks in advance.
If the street name always occurs after the first space,
you could use this calculated field in a query to break
out and sort on the street name. If there are variations
that would break this rule (e.g. 123 N. Main St.), then
you'll have to play with the idea to get at the string
following the 2nd space, etc.
StreetName: Right([address],Len([address])-InStr
([address]," "))
Just an idea.
that can look at an address (all in one field -
example "325 Providence Road") and have it sort by the
street name instead of the street number. I don't have a
way to break the street numbers out as a seperate field
because of the front end app. I thought about converting
each character from left to right to ASCII and then
looking for the first alphabetic character in the range of
ASCII characters and using that to sort by, but I can't
figure out how to do it. Does anyone have any other
suggestions? Thanks in advance.