Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do get information that does not agree in a query?

Discussion in 'Information Technology' started by Jim, Nov 17, 2005.

  1. Jim

    Jim
    Expand Collapse
    Guest

    I have two table.
    One tables have a list of address in the city.
    The other table has a list of address in all areas.
    I need an exception report to give me all address outside of the city.
    Any Ideas?
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    While not exactly what it was designed for, you should be able to use the
    Find Unmatched Query Wizard.

    Go to create a new query, select that option from the list of available
    choices and follow the instructions.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Jim" <Jim@discussions.microsoft.com> wrote in message
    news:F40F11CA-B176-4098-8D2A-38B100E3A43C@microsoft.com...
    > I have two table.
    > One tables have a list of address in the city.
    > The other table has a list of address in all areas.
    > I need an exception report to give me all address outside of the city.
    > Any Ideas?
     

Share This Page