summary

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
"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?
Click to expand...

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
 
Back
Top