reports

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Reports

Reports

resolvedResolved · 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


 

Access tip:

Action queries

Unlike 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.

View all Access hints and tips


Server loaded in 0.08 secs.