var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: changing e-mail alias via update queries
let's say in a table field i have firstname.lastname@example.org and would like to change all people with abc.com alias to abc-def.com alias, would this be possible?
so after running the query it would end up email@example.com
If you're doing it via VBA then take a look at the Replace Function. Else, an Update query should do the trick, using "@abc.com" as the WHERE criteria and careful use of the LEN and LEFT functions.
Me.Geek = True
You could do this with search and replace too. CTRL-H I think it is.
Owner and Manager of
CypherBYTE, Microsoft Access Development Specialists.
Microsoft Access MCP.
And all around nice guy!
"Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "