Multiple results from query.

[JLD]

I have three tables with a common primary key of property id. The tables are

property
owner
improvements

Each table has data in it I want to include to a report. I have linked the
property id to each of the others. But when I run the query I get multiple
results for each owner. Otherwise duplicate results. I have tired many
combinations to try and get the results with no results. In the relationships
window I can link the id fields but it does not give me the option to specify
one to many or vise versa.

Need help for work

JLD

 

[FSt1]

hi,
without seeing your data i can only guess but usually when you are getting
duplicate output, it is because you don't have enough links. Some querys
require multiple links. In some of the tables i work with, i sometimes
require up to 3 links to eliminate duplicate output. IF you have other common
fields in your tables, link those fields also along with your primary key.

good luck

FSt1

 

[KARL DEWEY]

If your duplication is the same property and owner information repeated for
each improvement in your report then just set the properties of the fields in
the report to Hide Duplicates.

 

[JLD]

I finally figured it out. I did not specify a year and I was pulling info
from mulitple years.

Thanks guys.

JLD