If Field "B" = FIELD "A" Then.....

[NeonSky via AccessMonster.com]

Hello All,

Quick question here. In the query design window I am creating a make table
query where if the value of field "A" is equal to the value of field "B" then
do not include record in query result.

Happy to provide additional info!

Thanks so much!!

 

[Al Campagna]

Neon,
In the A column use this criteria...
<>
All A records that = B will be dropped.

 

[Access101]

Let me know if this helps:

I create a Field in the query called MySort

MySort: IIF(A=B, "YES", "NO")

Then on the Criteria level of the query, I type in "YES".

This way only the records that have a YES will go into the Make Table.

 

[Klatuu]

In the Criteria row of FieldA:

<> FieldB

That will cause the query to include only those rows where the two fields
are not equal.

 

[NeonSky via AccessMonster.com]

Thanks everybody, truly do appreciate the input!!

 

[NeonSky via AccessMonster.com]

Awesome! really helped me because when dealing with multiple fields I
inserted OR statements in which worked perfectly!

Let me know if this helps:

I create a Field in the query called MySort

MySort: IIF(A=B, "YES", "NO")

Then on the Criteria level of the query, I type in "YES".

This way only the records that have a YES will go into the Make Table.

Hello All,

[quoted text clipped - 5 lines]

Thanks so much!!