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

reports

ResolvedVersion 2003

Duncan has attended:
Excel VBA Intro Intermediate course
Excel Advanced course
Access Introduction course
Access Intermediate course

Reports

How do you create graphs in reports?

Edited on Wed 7 May 2008, 10:25

RE: Reports

Hi Duncan, Thank you for your post, there are two answers to your question, so if you just want to create a simple graph from data, and have this displayed in the report;

1. In your report in design view choose Insert>Object and from the options choose Microsoft Graph Chart then on the example chart you can change the data in the grid to display the data marker values in your chart, this chart can be formatted and changed as required.

2. And this is the one that I like;
For example, lets say we have two tables

Access tip:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

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.11 secs.