Compare values in in two tables fields
I'm using two RS-s method to loop trough the data of both tables
Thank you for taking the time to report an issue.
What's wrong... Please write below.
If values in Column1 from Table1 does not match Values in Column1 from Table2 then display those values in a separate table
Is there a way to do this?
The Query Wizard for Unmatched doesn't quite accomplish what I am trying to do. If TableB is missing a row from Table A then it will return new rows if I select the two tables in the proper order (reversing will return nothing).
I still do not receive anything if simply one field for one row was changed (everything else the same).
I need to compare the user input to values in a table. The table is structured so that each record is relative to one specific field in the table (also one specific textbox on the form)and each record has three fields with values that determine a 'range'.
What I need to do is compare the user input (for each field) to the associated ranges in the table to 'grade' the input. The result will be to color textboxes, labels, etc. on the form based on this grading.
What is the most efficient way to do this?
Should I read the grading into an array and then compare each field (textbox on the form)?
Should I compare one field at a time to one specific record? (seems code intensive and very unforgiving when changes come)
Table1 - fields: Name, address, city, country
Table 2 - fields: Name, occupation
I need to compare the names in both these tables and see what names from table1 are not in table2.
I am trying to solve the problem of reviewing records from 2 different tables. Both tables have the same fields both in Name and type. There is 6 fields to each table to compare. Each field can have a different number up to 42. I am trying to see how many of the numbers in a given record for table 1 matches the records in table 2. below is an example of what I am doing.
N1 = 2 N1 = 5
N2 = 24 N2 = 2
N3 = 5 N3 = 10
N4 = 9 N4 = 31
N5 = 10 N4 = 36
N6 = 29 N6 = 28
Using the if statments I am currently using this will deliver me 3 matching numbers on 2, 5 and 10.
As I said I am using IF staments to this right now. Is there a better, more efficent way to accomplish the same thing. Tble1 is a small table but Tble2 has a large number of records and process time is about 25 minutes.
Lets I have B_Table in the Archive database and A_Table in the Production database. I need it to compare and let me know if there is anything that does not match but without linking tables or anything like that.
I opened them in access because what I want to achieve getting the unique values into one table.
So I made a query and I think I have done it correctly but I want to check as it's important. So from this one file I want the unique values is this correct?
SELECT First(Compare.[Email]) AS [Email Field], Count(Compare.[Email]) AS NumberOfDups FROM Compare GROUP BY Compare.[Email] HAVING (((Count(Compare.[Email]))>1));
It's made a query which I tried to export as CSV which failed for the silly reason of the clipboard only being able to hold 65k records so thats annoying. If anyone knows how to get round that that would help too
I currently have relationships between the three fields. I would like to be able to search equal between LASTNAME, FIRSTNAME, and 1st letter of MIDNAME. I don't know how to specify just the first character. So when working if one table has Mary A Roberts and the second has Mary Alice Roberts it will see them as being equal.