Table Compare with extra's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables:

tblPrimary:
Unkey CustCodeA
1 202
2 207
3 209

tblSecondary
Unkey CustCodeB
1 202
2 255
3 209

I want to output all records in tblPrimary and the output table to have the
following fields:

tblOutput
Unkey CustCodeA
1 Match
2 Error - 255
3 Match

Prefer solution in query builder, if possible.

Appreciate any help.
 
Mackia said:
I have two tables:

tblPrimary:
Unkey CustCodeA
1 202
2 207
3 209

tblSecondary
Unkey CustCodeB
1 202
2 255
3 209

I want to output all records in tblPrimary and the output table to have the
following fields:

tblOutput
Unkey CustCodeA
1 Match
2 Error - 255
3 Match
Click to expand...


SELECT tblPrimary.Unkey,
IIf(tblPrimary.CustCodeA = tblSecondary.CustCodeB,
"Match", "Error - " & tblSecondary.CustCodeB) As CodeA
FROM tblPrimary INNER JOIN tblSecondary
ON tblPrimary.Unkey = tblSecondary.Unkey
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup current record with ComboBox, any changes create new record 3
Excel Returning Multiple Results (closest Match Not Exact) From A Table Using Multiple Criteria 1
Check to see whether a table contains a set of fields already 1
form question with table question 2
Image file table update, code takes over 24 hours to finish....suggestions 13
Combining multiple records by summing 5
Comparing data between 2 tables 5
Update a table using the table as a recordset 1

Back
Top