Filter. Field1 = Field5 ???

Y

YuWing

I would like to ask how can I filter out the records with the first colume
same as the fifth colume.

for example, I want to filter out the records, which the billing address is
the same as the shipping address.
 
R

rowiga

The syntax would be just about as you showed it:

SELECT All of your selected fields
FROM Your table
WHERE (((YourTable.Field1)=[Field5]));
 
Y

YuWing

Thank you thank you~~~

rowiga said:
The syntax would be just about as you showed it:

SELECT All of your selected fields
FROM Your table
WHERE (((YourTable.Field1)=[Field5]));


YuWing said:
I would like to ask how can I filter out the records with the first colume
same as the fifth colume.

for example, I want to filter out the records, which the billing address is
the same as the shipping address.
Click to expand...
Click to expand...
 
Top