CHARTS DRIVING ME CRAZY

[netrusher]

I am trying to create a chart on a Form. In Excel I have no problems arranging my data. This is my first try for charts in Access. I have a table. I created a query summing two fields of this table:

Total Workers
Total Workers: DCount("[WorkerNameLast]","1-StationVerifyTbl","[ClockNbr]<>'*'")
Total Workers = 120

Total Verified
Verified Workers: DCount("[WorkerNameLast]","1-StationVerifyTbl","[StaPrimary]=True")
Total Verified = 43

So far so good. That is the correct information. What I want in a Chart is two bars side by side. One bar at 120 and the other bar at 43. I have tried everything and cannot get this to work. I am getting confused on the Axis, Data, & Series. I think I need another Field somehow. The totals I would call Monthly Totals

Could someone please help me get this thing started. I have wasted a week and feel like I have learned nothing except how to count in the Query.

After this I would like to be able to show a percentage of those verified. I have 120 workers and 43 are verified. That would be approx 35%. Anyway I am assuming that there is a solution and that I am just floundering for nothing. Thanks in advance.

 

[netrusher]

I guess I should close this post down. I have received no answers at all.

Anyone got any info on how to take information from an Access table and turn it into an Excel Chart Automatically?

 

[dmksas]

please see my reply on AccessVBA.Com



Danny

Never Think Impossible