98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Reports
Reports
Resolved · High Priority · Version 2007
Sarah has attended:
Access Introduction course
Reports
I need to create a report for individual people on our database. How would i go about this.
RE: Reports
Hi Sarah
Thank you for your question
Your best bet would be to first create a query that extracts the information you require, and filters on the salesperson's name so it just shows records for that person
You can then create your report using a wizard, and set it to get its data from the query
If you want your report to run for each salesperson, then you can remove the criteria from the query and when building the report set the report to group by salesperson
Hope this is useful
Regards
Stephen
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Action queriesUnlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read. |