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

reports

ResolvedVersion 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:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.