Logo
programming4us
programming4us
programming4us
programming4us
Home
programming4us
XP
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Windows Phone
 
programming4us
Windows 7

Microsoft Access 2010 : Creating Queries - Finding Unmatched Records

- How To Install Windows Server 2012 On VirtualBox
- How To Bypass Torrent Connection Blocking By Your ISP
- How To Install Actual Facebook App On Kindle Fire
6/8/2012 6:27:14 PM
When two tables are in a one-to-many relationship, you can create a Find Unmatched Records query to identify any records in the table on the "one" side that have no corresponding records in the table on the "many" side. For example, in the Northwind sample database, because the Customers and Orders tables are in a one-to-many relationship, you could identify customers that have never placed an order.

1. Create a Find Unmatched Records Query

  1. Click the Create tab.

  2. Click Query Wizard.

  3. Click Find Unmatched Query Wizard.

  4. Click OK.

  5. Click the table in which you want to find unmatched records.

  6. Click Next.

  7. Click the table or query with related records.

  8. Click Next.

  9. If necessary, click the field in the left pane that is in the table on the "one" side of the relationship.

  10. If necessary, click the field in the right pane that is in the table on the "many" side of the relationship.

  11. Click the Match button to identify the equivalent fields.

  12. Click Next.

  13. Click the name of a field to display in the query results.

  14. Click Add.

  15. Repeat steps 13 and 14 as needed to add fields to the display.

  16. Click Next.

  17. Type a name for the query.

  18. Click Finish.


Note:

Open the Northwind sample database, click the Create tab, click the Query Wizard button, click Find Unmatched Query Wizard, and then click OK. Click Table: Customers and then click Next. In the next screen, click Table: Orders and then click Next. Verify that ID is highlighted in the Customers table and that CustomerID is highlighted in the Orders table; then click Next. Click Company, click the Add button, and then click Next. In the final screen, click Finish to accept the query name Access suggests. The query you create displays customers that have not placed an order.

Other -----------------
- Microsoft Access 2010 : Creating Queries - Finding Duplicate Records
- Microsoft Outlook 2010 : Viewing Message Participant Information
- Microsoft Outlook 2010 : Configuring Reading Pane Behavior
- Deep Dive: Windows Home Server Features (part 2) - Remote Access
- Deep Dive: Windows Home Server Features (part 1) - PC Backup and Restore, Document and Media Sharing
- Microsoft Visio 2010 : Containers and Lists (part 2) - Lists
- Microsoft Visio 2010 : Containers and Lists (part 1) - Containers
- Microsoft Visio 2010 : Creating rule set reports - Getting the XSL stylesheet
- Microsoft Access 2010 : Using Queries to Calculate Values & Creating a Parameter Query
- Microsoft Access 2010 : Using Criteria to Focus Query Results & Introducing Operators
 
 
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
programming4us programming4us
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 windows Phone 7 windows Phone 8
programming4us programming4us
 
programming4us
Natural Miscarriage
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer