Duplicate data in report

  • Thread starter Thread starter Nicole
  • Start date Start date
N

Nicole

This is my first Acces project, and I am stuck. I need to send information
to different owners about income and expenses on properties which they own.
I created a report which pulls the total income and expenses for property and
it works great as long as the property has only one owner. When the property
has more than one owner, my detail data is duplicating - which duplicates all
income and expense. How can I change this report so that my detail data will
not duplicate for multiple owners?

Any suggestions would be greatly appreciated!

Nicole
 
How is the data stored? Do you have two records for the same property due to
two owners, each with income and expenses or is property with income and
expenses in one table and a one-to-many relationship to an owners table?
If latter just set the Hide Duplicates property of the income and expenses
text boxes to Yes.
 
Back
Top