Using MS Access/Report generation

Advertisement


Question
Hi Richard,

I used Access several years ago (version 2000) and now working on a small project for my golf club using Access 2007.  I have created a table with playing history for 50 or so players.  I now want to create a REPORT that I can provide to each player summarizing their playing history.

I have created 5 queries that extract the data I need.  Now I want to create a report using data from each query.  The report will be for individual players.  Basically, I want to enter a name and have a report created for that player using data from each query.

I have a Acess manual but it doesn't seen to touch on my problem.

Can you provide some quidance on the approach to use?

Thank you.

Gordon

Answer
I'd have to see how your queries are set up to tell you exactly what to do, but it sounds like you just need to join them all together and then create an AGGREGATE QUERY or a report with GROUPING LEVELS. Books are great, but if you don't know WHAT you're looking for, they're not much help.


Be sure to visit my web site and watch my FREE 2-hour-long Microsoft Access Video Tutorial

Cordially,
Richard Rost
Microsoft Access MVP
599CD Computer Training  

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Richard Rost

Expertise

I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site, and free Access 101 tutorial.

Experience

I am the president of AccessLearningZone.com and 599CD.com. I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.

Education/Credentials
I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com

©2016 About.com. All rights reserved.