Search results for query: *

Hey guys, I have a table (AMAC) that I wish to update based on another table with similar columns (OldAMAC). The fields they have in common are the Agreement ID, Member ID and the Committed field. The reason I'm doing this is because one of the tables (the one I wish to reference to when...

Hey Guys, I'm writing a quick query to combine the results of 2 tables. One has contract information (with contract ID) another is Member information (with Member ID). I have a 3rd table which was passed down to me by the person I replaced. This 3rd table is an "All Members and All contracts"...

Hey Everyone, I have 3 Tables. <Complete Contract List> - lists all the contracts available (2011 records) <Member list> - List all member information (657 records) <Complete List of Members and contracts> - Has a listing of every member and every contract that those members are committed...

Hey everyone! I am currently working on a database with 3 Tables. 1 is the customer list (657) with all their details, 1 is a contract list (2011) with all those details and the 3rd is a complete customer list with all the current contracts they are committed to (486,974). What I need to do is...

Hello, I am currently working on database where I need to compare 2 tables with each other and see which data in table 1 is not already in table 2. Table2 has a mix of data sorted by an ID number and table 1 is sorted by a another type of ID code. The problem lies here. Table 2 needs to have...

Hey guys! I found your site, and thank goodness I did, I'm actually stumped on this. Hopefully one of you can help. I have 2 tables Contract table (we'll call Con) Complete Member list with contracts table (we'll call Mem) Con has 5 fields, Agreement number, Agreement name, Date accepted...