Comparing two fields.

[andy982183]

Hello,

I am a Beginner in MS Access and SQL and I need a query to compare two fields.

I am having two tables; T1 and T2, and I want to compare their
fields TF1 and TF2, and display the non matching fields in new
field.

Example:

Table T1
TF1

Location Louisville
Number 555345
Name Smith


Table T2
TF1

Location Louisville
Number 553450
Name Smythe


Thanks in Advance.

 

[pgraju]

Database Design...

Hi andy,

It might be a good idea to reconsider how you are setting up your tables, rather than have all the information about a customer/employee/person in one field, why not try and split it up.

So for example.

Example Table
Person_Id
Person_Name
Person_Address
Person_Postcode
Person_Suburb
Person_PhoneNumber
Person_MobileNumber

Then do a simple equal join on the fields you would like compare between the tables.

If you need some more help pm me.

Prashant