trying to filter data,,,help please

M

maxxximaniac

Registered User.

Local time

Today, 13:50

Joined

Oct 22, 2004

Messages

80

• Oct 22, 2004

• #1

I have two fields in a table.
i.e.
ROW A ROW B

I need to filter out all the data where row a = row b

anyone know how to do this... im sure its easy i just cant think of it
any help is appreciated..
thanks!

 

sfreeman@co.mer

Sam_F

Local time

Today, 13:50

Joined

Aug 2, 2004

Messages

272

• Oct 22, 2004

• #2

Hth

SELECT
tblTesting.RowA
, tblTesting.RowB

FROM
tblTesting

WHERE
(((tblTesting.RowA)=[RowB]));

 

M

maxxximaniac

Registered User.

Local time

Today, 13:50

Joined

Oct 22, 2004

Messages

80

• Oct 22, 2004

• #3

im not quite following you...
insert this code into?

 

M

Mcp

New member

Local time

Today, 16:50

Joined

Oct 22, 2004

Messages

5

• Oct 22, 2004

• #4

SELECT *
FROM tblTesting
WHERE RowA <> RowB;

??

 

M

Mcp

New member

Local time

Today, 16:50

Joined

Oct 22, 2004

Messages

5

• Oct 22, 2004

• #5

maxxximaniac said:

im not quite following you...
insert this code into?

Click to expand...

While in design view of your query Select VIEW > SQLView
Then type it in...

 

M

maxxximaniac

Registered User.

Local time

Today, 13:50

Joined

Oct 22, 2004

Messages

80

• Oct 22, 2004

• #6

what is tblTesting

here's the exact scanario

Table name: mbna
Rows are TRNDTE and TRNEFD

 

M

maxxximaniac

Registered User.

Local time

Today, 13:50

Joined

Oct 22, 2004

Messages

80

• Oct 22, 2004

• #7

k im gonna try

 

M

maxxximaniac

Registered User.

Local time

Today, 13:50

Joined

Oct 22, 2004

Messages

80

• Oct 22, 2004

• #8

i want to take out the rows where the rowa = rowb

 

M

maxxximaniac

Registered User.

Local time

Today, 13:50

Joined

Oct 22, 2004

Messages

80

• Oct 22, 2004

• #9

ah i got it
intead of = i put <>

thank you VERY much for your help!