summary

[Guest]

can i list records then do a summary line? I am doing a phone list. I need
to sort by last name. I want to put everyone with same last name and same
address in the detail, then do one line that lists the common address?

 

[Larry Linson]

"Access Report Summary on Detail" <Access Report Summary on
(e-mail address removed)> wrote in message

can i list records then do a summary line? I am doing a phone list. I
need
to sort by last name. I want to put everyone with same last name and same
address in the detail, then do one line that lists the common address?

If each record has the identical address information, you may be able to do
what you want with Sorting and Grouping, and specifying either a Group
Header or a Group Footer. But, it may be that you'd be better off to take a
look at the design of your tables to see if you can reduce redundancy by
moving the common addresses to a separate, related table.

Larry Linson
Microsoft Access MVP