duplicate data in a report

[Joe the cop]

I have one table of several fields, name, address, telephone. Some people
have more than one telephone. I have a report that lists name, address,
telephone. I want the report to list the name, address and first telephone
accross one line, and any additional telephone numbers under the first
telephone number. But I do not want to the name and address to repeat on
each line, only the telephone. Also, I cannot use linked tables. Thanks.

 

[Jeff Boyce]

Joe

I'll assume your current query returns multiple rows for the same person, as
many as you have phone numbers. (and if this is not the case, your data may
need some additional normalization!)

In a report definition, you can specify that a control does NOT re-display
duplicate data. In your situation, if you had the name/address/phone
controls in the detail section, and set the first two not to display
duplicate values, you'd see the first "line", then only the additional phone
numbers, each on a line of their own. (Again, this requires a
datasource/query that returns one row per valid combination.)

Regards

Jeff Boyce
Microsoft Office/Access MVP