Filter. Field1 = Field5 ???

G

Guest

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.
 
G

Guest

The syntax would be just about as you showed it:

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top