Duplicate data in report

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
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top