Summarizing Detail Records

  • Thread starter Thread starter Tom c
  • Start date Start date
T

Tom c

I have Office 2003, using MS Win XP. In my data base, I
have a record with data elements Last Name, First Name
and Year. I have one record for each year a person
attended an event. Instead of doing a detail listing, I
would like to print one summary line for each person and
print the years horizontally (no more than 6 years) that
they attended the event. How do I do this with Access?
I've tried several things, and while it gives me grouping
and summarizing options, it appears that it does not let
me do any IIF functions for the summary line? Thanks for
any help or direction you can give me.
 
Look in Help at Cross-Tab Queries (and Pivot Tables, if using Access 2002 or
2003)... I think that may be what you need. A good book for the intermediate
to advanced level user might be a worthwhile investment -- browse in a local
bookstore, well-stocked with computer books.

Larry Linson
Microsoft Access MVP
 
Back
Top