Recent content by TPH

That worked great, thank you!

Thank you both for the quick replies. Alright...I tried changing it to an Update query but the example below doesn't update anything: UPDATE Table01 INNER JOIN Table02 ON Table01.ID = Table02.ID SET Table01.ID = [Table02].[ID] WHERE (([Table01].[ID] Is Null)); Sorry, I'll try to go into a...

Hello guys, I have a simple problem of combining two tables, as shown below. I guess I wasn't able to find the right search terms for what I need. Sorry about the English. Table 01: ID | Data <null> A <null> B <null> C Table 02: ID | Data 01 <null> 02 <null> 03 <null>...

Just for future reference, the issues have been solved! h_ttp://forums.techguy.org/business-applications/1112787-assigning-matching-ids-one-table.html

Assigning matching IDs from one table to another Hi all, I've been struggling with this problem for a few days now...I'm not that experienced at Access, so hopefully I'll be able to explain it properly for everybody. A while ago I was tasked with creating a compliance testing database for my...