charts
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Charts

resolvedResolved · Low Priority · Version 2003

replyReply Mon 31 Jan 2011, 15:50Delegate Suki said...

Suki has attended:
Access Introduction course

Charts

Are you able to show charts and graphs to show data that is produced from queries?

For upcoming training course dates see: Pricing & availability

replyReply Tue 1 Feb 2011, 14:06Trainer Anthony said...

RE: Charts

Hi Suki, thanks for your query. Access doesn't have built-in charting functionality. Best bet is to export the query results to Excel and employ it's charting tools.

Hope this helps,

Anthony

 

Please browse our web site to find out more about
access courses and other Microsoft training courses.

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard