Update a field based upon the content of another field in other ta

W

Wendy

Hi,
I'm trying to consolidate 3 different databases - it's a bit of a nightmare
and requires a various number of passes to achieve the final result.

I have an email address field in one table that I want to move across to
another table based upon the critieria match I currently have. I'm not
bothered about redundancy or normalisation at this stage as once I've got the
email address, I'm dumping the table.

I don't particularly want to have to Make Table to get this done as there
are so many criteria/configurations I have to get through; plus these are all
subsets.

Any ideas?

Ta
 
M

Michel Walsh

Your problem is probably crystal clear for you, but not for us; at least,
not for me.

Use INSERT INTO, an append query, is the only answer I can make.


Vanderghast, Access MVP
 

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

Need to update records in a table based upon records in another ta 2
Update field with contents of another field 1
Update Value in Table based on to that of Another Field 1
Modifying a field in one table with data from another table 2
Update Query based on calc. Field in another query 2
Create IN criteria from another table 1
How to limit list of a field based on another field in the same ta 6
Conditional update of field based on the same field in previous re 3

Top