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?
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