How to create a query for comparing 2 fields from a table

[syemaat]

Hello!!!!!!!!

In MS ACCESS i need to create a query that compares 2 fields from a single table and generate a report or redirect to a report which should consist of matched data among 2 fields and unmatched data seperately from field1 and field2.

[MindBender77]

Hello!!!!!!!!

In MS ACCESS i need to create a query that compares 2 fields from a single table and generate a report or redirect to a report which should consist of matched data among 2 fields and unmatched data seperately from field1 and field2.

It might be easier to create 2 separate queries. One for matched data and the second for unmatched data. Then create the report(s) based on those queries.

Hope this points you in the right directions,
JS

[syemaat]

It might be easier to create 2 separate queries. One for matched data and the second for unmatched data. Then create the report(s) based on those queries.

Hope this points you in the right directions,
JS

Fine then what will be the query for matching and unmatching in access

[MindBender77]

Hello!!!!!!!!

In MS ACCESS i need to create a query that compares 2 fields from a single table and generate a report or redirect to a report which should consist of matched data among 2 fields and unmatched data seperately from field1 and field2.

Try this for Matching:

SELECT Field1, Field2
FROM YourTable
WHERE (((Field1)=[Field2]))
GROUP BY Field1, Field2;
 

Then for Unmatching:

SELECT Field1, Field2
FROM YourTable
WHERE (((Field1)<>[Field2]))
GROUP BY Field1, Field2;
 

Hope this Helps,
JS

[syemaat]

Try this for Matching:

SELECT Field1, Field2
FROM YourTable
WHERE (((Field1)=[Field2]))
GROUP BY Field1, Field2;
 

Then for Unmatching:

SELECT Field1, Field2
FROM YourTable
WHERE (((Field1)<>[Field2]))
GROUP BY Field1, Field2;
 

Hope this Helps,
JS

In Access where do we write queries like these.........It seems to be as SQL Query.If i am wrong plz do correct me and tell me where do i write this query in MS access

[MindBender77]

In Access where do we write queries like these.........It seems to be as SQL Query.If i am wrong plz do correct me and tell me where do i write this query in MS access

You can write these sql queries in access by opening a query in SQL View from the query designer.

JS

[syemaat]

You can write these sql queries in access by opening a query in SQL View from the query designer.

JS

One more doubt!!!!!!!!!!

Every item of Field1 should be compared to all attributes of Field2 and then produce the result...............(ie)comparing all items of Field 1 to Field2 and then producing the common items in bith the Fields..............i think this time have put up my right question.............plz do tell me how the query has to be written(codings)

[syemaat]

You can write these sql queries in access by opening a query in SQL View from the query designer.

JS

One more doubt!!!!!!!!!!

Every item of Field1 should be compared to all attributes of Field2 and then produce the result...............(ie)comparing all items of Field 1 to Field2 and then producing the common items in both the Fields..............and even not matching ones..........i think this time have put up my right question.............plz do tell me how the query has to be written(codings)