I have two tables in Access 2007 for email campaigns that I have been sending out. I have a field in one table called Touched (this is how many times I have sent this client an email). Is there a way to add "1" to the Touched field in an Append query.
I have a table that contains my clients (Clients) and a table that has the latest emails (Emails) of clients that I have sent to. I have both tables up in an Append query and I have joined on Email and simply want to add 1 to the Touched field.
Does this make sense?