« I need instructions on how to access the calculator application on a mac computer?
How do I receive all data when sending microsoft access data base from computer with 2003 to one with 2007? »

How to make queries in MS Access which require three columns to match?

OK

say I have an access table with 4 columns, A, B, C, and D. How can I make a query which requires column A = x, B=Y, and C=Z and return the value in column D?

Thanks for any help. I am making my queries in design view in access 2003.

Just use Queries and get all table you would like to use for your requirement, drag the columns to relate the tables, more than one relations are permitted, use join type like outer joins by double clicking the relation path/line. select the field/s you would like to show and you can further add criteria to it!!! For more goto http://www.utteraccess.com/forums/

This entry was posted on Wednesday, March 3rd, 2010 at 1:13 am and is filed under access queries. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “How to make queries in MS Access which require three columns to match?”

  1. Gohaleg Says:
    March 3rd, 2010 at 6:37 am

    Well this is kind of rusty but lets see

    SELECT D FROM [table here] WHERE A==x && B==y && C==z

    keep in mind that if those values are Strings you are better of using like this: A LIKE x
    References :

  2. Rahul Says:
    March 3rd, 2010 at 7:14 am

    Just use Queries and get all table you would like to use for your requirement, drag the columns to relate the tables, more than one relations are permitted, use join type like outer joins by double clicking the relation path/line. select the field/s you would like to show and you can further add criteria to it!!! For more goto http://www.utteraccess.com/forums/
    References :
    http://www.utteraccess.com/forums/

Leave a Reply