Welcome to SPN

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

Sign Up Now!

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

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

  1. xRoachx

    xRoachx
    Expand Collapse
    Guest

    First, I would have only 1 table of address rather than 2. Anyhow, do you
    mean you need to report on all of the addresses outside of the city in the
    second table? If so this is easy to accomplish through a query. Create a
    query and in the field that holds the city names, exclude the city in the
    criteria: <> "City Name"

    "Jim" wrote:

    > 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...


Share This Page