Recent content by joeyT

Thanks for your response. No I want the data to end up in Access. I guess I will have to enter these in the SQL view of the query if I am not wrong

Hello, I am wondering if there is an efficient way to compare two fields from one table to another two fields from another table. So basically If targetTable.Field1.Value = sourceTable.Field1.Value And targetTable.Field2.Value = sourceTable.Field2.Value Then targetTable.Field3.Value =...

Hello, As shown in the following, I have two tables in my Access database. Table 1 has three columns, First Name, Last Name and Phone Number. Table 2 has just 2 columns, First Name and Last Name. What I would like to do is write a VBA macro to consolidate Table 2 into Table 1 and insure any...