Not equal

  • Thread starter Thread starter mike via AccessMonster.com
  • Start date Start date
M

mike via AccessMonster.com

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.
 
Create an unmatched query. When you select "New Query" you can run the
"Find Unmatched Query Wizard".
 
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!
 
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
 
thanks

Michel said:
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,
Click to expand...
[quoted text clipped - 13 lines]
not
equal in field1 & field2.
Click to expand...
Click to expand...
 
thanks
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,
Click to expand...
[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.
Click to expand...
Click to expand...
 
thanks
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,
Click to expand...
[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.
Click to expand...
Click to expand...
 
this one is good it works ,,,thanks a lot
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,
Click to expand...
[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.
Click to expand...
Click to expand...
 
Back
Top