Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2006
    Thanked 0 Times in 0 Posts

    Find unmatched query (access 2000)

    can you help me build un unmatched query ? I cannot use the wizard because it has not been installed on my my computer.i have 2 identical tables called gardens and i want to find which trees do nor correspond.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Find unmatched query (access 2000)

    - Create a new query in design view.
    - Add the two Gardens tables.
    - Join the two tables on the field that identifies the tree (drag the field from one table to the corresponding field in the other table.
    - Double click the line joining the two tables.
    - Select the option to return all records from the table on the left, and only related records from the table on the right.
    - Add fields from the table on the left to the query grid.
    - Also add the field identifying the tree from the table on the right to the query grid.
    - Clear the "Show" check box for this field.
    - Enter Is Null in the criteria line for this field.
    - Switch to datasheet view.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts