Update Query in Access

G

Guest

I have a table which contains a field called Email and a field called Login.
The Login is identical to the the email MINUS the @starkstate.net. Is there
an expression I can use in an update query that would update the Login field
with all characters from the Email field MINUS the @starkstate.net? Any help
is appreciated.
 
D

Douglas J. Steele

If the one field is always a subset of the other, you shouldn't be storing
both. Instead, you should have a computed field in a query that determines
Login as Left((e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting characters from a field with Access 2003 3
AOL email scam 2
Update Query Questions 7
Need Help with Update Query 4
Help with Update Query 2
Update query 2
Special characters 3
Expresion field to update to field in table 3

Top