Not equal

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mike - 26 Sep 2005 15:39 GMT

Hi,

How can i query a table that will select only for those two tields are not
equal.

ex.
Table1

stockno description field1 field2
1 tools 40 30
2 box 30 60
3 paper 20 10
4 towel 15 15

I want my query result to display only the stockno 1,2 & 3 'coz those are not
equal in field1 & field2.

Reply to this Message

Rick B - 26 Sep 2005 15:44 GMT

Create an unmatched query. When you select "New Query" you can run the
"Find Unmatched Query Wizard".

Signature

Rick B

> Hi,
>
[quoted text clipped - 12 lines]
> I want my query result to display only the stockno 1,2 & 3 'coz those are not
> equal in field1 & field2.

Reply to this Message

mike - 27 Sep 2005 05:12 GMT

thanks

>Create an unmatched query. When you select "New Query" you can run the
>"Find Unmatched Query Wizard".
[quoted text clipped - 4 lines]
>> I want my query result to display only the stockno 1,2 & 3 'coz those are not
>> equal in field1 & field2.

Reply to this Message

Chaim - 26 Sep 2005 15:52 GMT

SELECT * FROM [Your Table]
WHERE [field1] <> [field2];

In the QEB,

Drag '*' to grid with no criteria. Drag field1 to grid, set Show to blank,
and set Criteria to
'<> [field2]'

Good Luck!
--

Chaim

> Hi,
>
[quoted text clipped - 16 lines]
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200509/1

Reply to this Message

mike - 27 Sep 2005 05:13 GMT

thanks

>SELECT * FROM [Your Table]
>WHERE [field1] <> [field2];
[quoted text clipped - 15 lines]
>> I want my query result to display only the stockno 1,2 & 3 'coz those are not
>> equal in field1 & field2.

Reply to this Message

mike - 27 Sep 2005 05:14 GMT

thanks

>SELECT * FROM [Your Table]
>WHERE [field1] <> [field2];
[quoted text clipped - 15 lines]
>> I want my query result to display only the stockno 1,2 & 3 'coz those are not
>> equal in field1 & field2.

Reply to this Message

mike - 27 Sep 2005 05:47 GMT

this one is good it works ,,,thanks a lot

>SELECT * FROM [Your Table]
>WHERE [field1] <> [field2];
[quoted text clipped - 15 lines]
>> I want my query result to display only the stockno 1,2 & 3 'coz those are not
>> equal in field1 & field2.

Reply to this Message

Michel Walsh - 26 Sep 2005 16:12 GMT

Hi,

SELECT * FROM myTable WHERE field1 <> field2

That is the SQL statement produced behind the scene. Switch back in design
view to see what could have been done, graphically, to produce it, there.

Hoping it may help,
Vanderghast, Access MVP

> Hi,
>
[quoted text clipped - 13 lines]
> not
> equal in field1 & field2.

Reply to this Message

mike - 27 Sep 2005 05:13 GMT

thanks

>Hi,
>
[quoted text clipped - 11 lines]
>> not
>> equal in field1 & field2.

Reply to this Message