B
bird lover
Field [address] contains multiple addresses, i.e 121 Main Street, 106-20A
20th Avenue.
Goal: move data into two fields, [streetsort] and [numbersort] so that
[streetsort] contains just addresses, i.e Main Street, Broadway, 5th Avenue,
while [streetnumber] contains just numbers. Purpose: to sort street names,
then subsort via street numbers.
I use access 2003, and don't know programming. If you can provide sample
syntax for an update or other type query, same would be appreciated.
20th Avenue.
Goal: move data into two fields, [streetsort] and [numbersort] so that
[streetsort] contains just addresses, i.e Main Street, Broadway, 5th Avenue,
while [streetnumber] contains just numbers. Purpose: to sort street names,
then subsort via street numbers.
I use access 2003, and don't know programming. If you can provide sample
syntax for an update or other type query, same would be appreciated.