How to create a query to compare values if they match or not and produce report about it ?

[hanialbarni]

Hello


Good morning

Can someone explain to me how can I create a query to compare Processingnumber from table1 with Processingnumber from table 2 if they are match or not the values, same goes for Amtvalue from Table 1 with Table 2.

[June7]

Are those ID fields both autonumber type?

Maybe you need a Find Unmatched query. There is a wizard.

[hanialbarni]

ID is Autonumbered
Processingnumber is number
Amtvalue is number

Am checking the wizard but what do I need to choose from settings ?

[hanialbarni]

Ok I was playing with it and it worked for Table 1 without Matching Table 2.
But what do I need is to show results if Table 1 = Table 2 values.

How can I do that ?

[June7]

How are these tables related?

Are the ID fields autonumber type?

Can you join them on the ProcessingNumber fields?

You want to see only records where Amtvalue fields are equal?

Build query that joins the tables and apply filter critera to one of the Amtalue fields, Table1: =[Table2].AmtValue

[hanialbarni]

Yes the ID is autonumber type, I don't know how can I join them on processing number, I need to check

Table1 Processingnumber if equal Table 2 Processingnumber

Table1 AmtValue if equal Table 2 AmtValue

If they are equal, it should produce a list or show the results of the ones that are equal which rows I mean.

[June7]

Did you trying building the suggested query?

[hanialbarni]

Yes I did as you can see there is something wrong, do u have an idea why it shows that ? and how can I solve it ?

[hanialbarni]

I write the Criteria like this in Table 1 Amtvalue

[Table1].[Amtvalue]=[Table2]![Amtvalue]

The result is empty

[June7]

Make no sense to link on two autonumber fields. They are independently generated, neither has any relationship to the other.

[hanialbarni]

You were right after I removed the link and write the following criteria

Table1.Amtvalue = Table2.Amtvalue

it does work and show the correct results