G
guidop12
I really can't think today, I have a table that has a Title/Prefix field
which contains both Titles and Prefixes(ex
resident for title and Mr. and
Mrs. for prefixes) I would like to take all the Mr and Mrs out of the field
and update them to a field called prefix.
I thought I could use an update query with the following
Field Title/prefix
Tbl cpyOutlook
Update to Prefix
Criteria Like "m*"
but that just takes all the m's but doesn't put them in the prefix field
Can anyone help
thanks
which contains both Titles and Prefixes(ex
resident for title and Mr. andMrs. for prefixes) I would like to take all the Mr and Mrs out of the field
and update them to a field called prefix.
I thought I could use an update query with the following
Field Title/prefix
Tbl cpyOutlook
Update to Prefix
Criteria Like "m*"
but that just takes all the m's but doesn't put them in the prefix field
Can anyone help
thanks