Need query to find missing field data

[narendrabr]

Hi,



I have attached a database that contains two tables Table1 and Table 2.Two tables have some fields but First name Last Name and Company name fields have in common.

What I need to find is the email field and put that in the query table.

Query table should be Fist name last name company name and email address.
Please provide the query and also how we can give relationship between tables?

Thanks

[June7]

Linking fields are LastName, FirstName, CompanyNmae. This is known as a compound unique ID.

Building queries that join tables is basic Access functionality. Use query designer. Access Help has guidelines.

You really need to get a better understanding of relational database concepts. Review:
http://forums.aspfree.com/microsoft-...es-208217.html
http://forums.aspfree.com/microsoft-...os-197463.html

[narendrabr]

Hi,

Please provide the query or steps to get the required results.

Thanks

[June7]

Use the query designer. Link the tables on the composite (compound) key fields.

http://www.opengatesw.net/ms-access-tutorials/Access-Articles/Microsoft-Access-Query.htm