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?