Need aueries to return values

[narendrabr]

Hi,

I have two tables called Email and Code,



I need query to return all emails that code field in code table with code field in email table.

Attached the sample database.

Also please provide the steps to where I should write queries as I am new to access.

Thanks!

[jzwp11]

I'm not sure I understand exactly what you want for the result. If you want all e-mails from the e-mail table that have codes that exist in both the e-mail table and the code table, you would just create a new query that includes those two tables and join them via the code fields in both tables. To do this go to Create-->Query Design. When prompted, add the two tables. Click on the code field of the email table and drag it to the code field of the code table to make the join. Then add the fields you want the query to display in the lower grid of the design window.

If that is not what you are after, you will have to explain a little further and perhaps provide an example of the output you hope to achieve with the query.