Update Query

[dweekley]

We have a database with limited access for updating (no find and replace available). As of now, I have 3 customers requiring their email address to be updated. I am using

 Expr1: Left([Contact.Email_Address],Len([Contact.Email_Address])-13) & "somewhere.com"

. But of course I have to count the number of characters for the domain on each use (room for error). I was trying to search to the @ with no luck. Any assist would be greatly appreciated.

[orange]

Do you know the Customer numbers?
Write a SELECT query to show all the Customer info for those Customers.
Back up your table.
Identify the existing email addresses.

Are you going to do this using UPDATE queries? Or are you going to modify the values in the table?

You are talking about 3 records -- what exactly is the difficulty?

[dweekley]

I have limited access to the DB. Updated records can only be done through using the update query. Regarding records, there are 3 customers that I have to update, totaling over 250 contacts. This DB is restricted. I can not alter records directly.

[June7]

Did you try:

Left([fieldname], InStr([fieldname],"@")) & "somewhere.com"

and don't forget the WHERE clause in the UPDATE action

[orange]

Please show us a jpg of your tables and relationships, or tell us clearly how Customers and Contacts are related.

I'm not following this

I have 3 customers requiring their email address to be updated

and

Regarding records, there are 3 customers that I have to update, totaling over 250 contacts.

[dweekley]

All set. Thank you. The quotes around fieldname was the issue. I had them around the second, and yet it works with no "".

[orange]

Just a caution:

Update queries can be very unforgiving. Backup your data.
Test your criteria by using a SELECT query to make sure you are dealing with the correct records and fields.

[dweekley]

Thanks you for the advise. I do run a select first, then create my update query. Also check record count between the 2. To much risk just jumping in. Thanks again.

[June7]

Sorry, I shouldn't have put quotes around [fieldname]. Typing error. Fixed post.