MS Access Chart

[Georgi]

Good evening everybody,



I have built an access database for training purposes, I the matrix I have created a combo box to see the accomplishement i.e. [Required], [Not Required] and [Completed], how can I create chart shows the sum of ([Completed]+[Not Required])/sum of ([Required], [Not Required] and [Completed]) in order the get the percentage of the completed sessions. Is there any idea how to do it with Access 2003? Please note I have an excellent skills with Excel I just start working with Access.

Please see below pictures.

Thank you in advance.

[June7]

The data example you show does not fit the graph example. Need sample of raw dataset. If you want to provide db for analysis, follow instructions at bottom of my post.

[Georgi]

The data example you show does not fit the graph example. Need sample of raw dataset. If you want to provide db for analysis, follow instructions at bottom of my post.

That's right, please see attached mdb. file, the problem is I made the calculation on my own way to get it correctly in the report, just trying to use excel way however, what I need is to get the chart shows the total percentage of the [completed] field + the [not required] field.

Thanks again,

[June7]

Why divide by Sum(Required)?

See using this query as datasource for further manipulation of data for graphs:
SELECT Course, Sum(IIf([Requirement]="Completed" Or [Requirement]="Not Required",1,0)) AS CompNR, Sum(IIf([Requirement]="Required",1,0)) AS Req, Count(ID) AS CountOfID
FROM [Training Matrix Subform]
GROUP BY Course;

[Georgi]

Why divide by Sum(Required)?

See using this query as datasource for further manipulation of data for graphs:
SELECT Course, Sum(IIf([Requirement]="Completed" Or [Requirement]="Not Required",1,0)) AS CompNR, Sum(IIf([Requirement]="Required",1,0)) AS Req, Count(ID) AS CountOfID
FROM [Training Matrix Subform]
GROUP BY Course;

Good evening again,

Thank you for your quick response, please see attached excel worksheet, it shows exactly what I am looking for, excuse me I am a beginner with access probably I did not understand you properly.

Have a look please,

[June7]

Easier to show than explain. Review attached file.

[Georgi]

Easier to show than explain. Review attached file.

Good morning, you just brilliant! Thanks a lot that's what I was looking for.

Have a good day,