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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NeonSky - 23 Aug 2006 22:18 GMT

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!!

Reply to this Message

Al Campagna - 23 Aug 2006 22:28 GMT

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

Signature

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

> Hello All,
>
[quoted text clipped - 5 lines]
>
> Thanks so much!!

Reply to this Message

Access101 - 23 Aug 2006 22:30 GMT

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!!

Reply to this Message

NeonSky - 24 Aug 2006 17:03 GMT

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

>Let me know if this helps:
>
[quoted text clipped - 11 lines]
>>
>> Thanks so much!!

Reply to this Message

Klatuu - 23 Aug 2006 22:30 GMT

In the Criteria row of FieldA:

<> FieldB

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

> Hello All,
>
[quoted text clipped - 5 lines]
>
> Thanks so much!!

Reply to this Message

NeonSky - 24 Aug 2006 15:42 GMT

Thanks everybody, truly do appreciate the input!!

Reply to this Message