H
Harvey DeLoya
I use msaccess 2000 and windows 2000.
In a list of adddress, I wish to eliminate the street
suffix. i.e.
123 Howard Avenue Remove Avenue
42 St. Marks Place Remove Place
My sense is go to the end of the record, find the first
open space to the left, then delete to the right, but I
don't know the syntax. A copy sent to HarveyDeloya at
Yahoo.com would be appreciated.
In a list of adddress, I wish to eliminate the street
suffix. i.e.
123 Howard Avenue Remove Avenue
42 St. Marks Place Remove Place
My sense is go to the end of the record, find the first
open space to the left, then delete to the right, but I
don't know the syntax. A copy sent to HarveyDeloya at
Yahoo.com would be appreciated.