Query to Populate a Field with Part of Contents from Another Field

A

Annie

Using Access 2003, I need to populate a Domain field which is currently
blank. The information already exists as part of the Email address field. Is
there any way to build an update query expression that would, for example,
populate field with company.com if the Email address is [email protected]?
I have 140,000+ records, so cannot parse on the @ sign in Excel. I suppose I
may have to do this, but I am hoping Access has a way. Any ideas or help
greatly appreciated. Thank you.
Annie
 
A

Annie

Allen, thank you so much. I ran an update query and this worked perfectly! I
never used Instr before. You have saved me hours of work. Again, thank you.
Annie

Allen Browne said:
Use Instr() to locate the @, and Mid() to get the rest of the string.

In a fresh column of the Field row in query design, you will end up with
something like this:
Mid(, Instr([Email], "@") + 1)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

[QUOTE="Annie"]
Using Access 2003, I need to populate a Domain field which is currently
blank. The information already exists as part of the Email address field.
Is
there any way to build an update query expression that would, for example,
populate field with company.com if the Email address is
[email protected]?
I have 140,000+ records, so cannot parse on the @ sign in Excel. I suppose
I
may have to do this, but I am hoping Access has a way. Any ideas or help
greatly appreciated. Thank you.
Annie[/QUOTE]
[/QUOTE]
Click to expand...
 
Top