duplicate values in report

[dilee]

When I print my report, it has duplicate values even when I put it on hide duplicates. I have a date of delivery, amount of delivery, payment amount and a date of payment. It seems that the date of payment repeats itself for each date of delivery. Can anyone help me find out why?
Thanks in advance for your help!

diana

 

[dhookom]

Look at the datasheet view of your report's record source. You will see duplicate values. Your Payments and Deliveries are possibly related to the same table but not to each other. You may need to place either Payments or Deliveries or both in subreports.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.