I have a table that lists OWNERS and UNIT/WEEKS owned, where a given owner may own more than one UNIT/WEEK, in which case the owner will have multiple records in the table. When printing envelopes for billing statements, I would like to only print one envelope per owner, in which multiple billing statements can be mailed. How do I modify my envelope printing report so as to print only one envelope per owner?

Hi


You should have only one table for owners and another related table for the units they own - and probably another for the weeks.

Can't be any more specific without knowing more about your data model, but it really looks like you need to normalise your db which will, amongst other things eliminate the current problem you're having.

Have a look here for loads of info...........

HTH

Alan