criteria

T

Tom van Stiphout

On Fri, 26 Mar 2010 22:15:47 -0700 (PDT), soha <[email protected]>
wrote:

Yes. For example in this example FirstName is a field that is used as
criteria for the LastName field:

select * from Contacts
where FirstName = LastName

-Tom.
Microsoft Access MVP
 

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

Similar Threads

Data consolidation 0
2 independent criteria in a query 2
Cascade queries 7
Can I save a sql statement generated by a search form? 1
Page numbering with Merged Document and IF statements 1
about filtering 2
NOT function not working - can prove with screenshots 1
Query based on Check Box 1

Top