Urgent Help Needed

I'm no expert in MS Access.

My boss asked me to knock up a database to record all those who have done the mandatory Health & Safety Briefings.

So I knocked up the field headings as so:

Surname Passed test? Date Passed?
(Text) (Tick box) (Medium date format)

I can now produse a report with all those who have done it (ticked) and all those who havent (unticked).

My boss now needs to submit a percentage of all those who have passed the test.

My question is:

How do I count up the number of people in the database?

How do I count the number of ticks?



Thank you in advance for any help you can give.

Fallyhag

Have a look at the attached sample db.

It is one that I have use to answer other post, so just look at the report.

Open in design mode and look for =Abs(Sum([sports])) that is what you need to count your ticks. Change sports to the name of your field. If you dont know how to do it, In the report footer put an unbound text box and in the control source enter
=Abs(Sum([name_of_yourfield])).

Let me know if this is what you wanted.




Regards

Thank you very much for your help in this matter.

As a follow on question:

Is there a way of turning these figures into a graph chart to display on a report?

Thanks again

Fallyhag

Yes you can show information in a chart.

1. Look in help for "charts"

2. Open Reports and click new and select Chart Wizard.



Regards,

Sorry, I should have made it clearer.

There are 46 employees, alll of which have to complete 12 mandatory tests. To indicate whether they have passed I have to enter a tick in the field.

Thanks to you I now know how to get the numbers of tick boxes totalled up so I now know how many have passed.

What I need to do now, coz my boss is asking for it, is a lovely graph to graphically represent our firms progress.

My problem is that I do not have the typical chart data to pick from, just some tick boxes?

Any suggestions?

Thanks again in advance

Fallyhag

You wrote:
My problem is that I do not have the typical chart data to pick from, just some tick boxes?

Tick "tick boxes" have a value. As I said in my previous post have a look at Charts in help. Did you try using the Chart Wizard as a starting point.

Use the same data source (table1) for the chart has I used for the report. Select the field sports and use that you will see that it give you 4 yes and 5 no.

To teach youself Acess you must read the help and try things, you cannot expect other people to do it for you. To make the chart wizard set up a chart in the sample database should take you about 20 seconds....Try!!!!

Good Luck, I don't want to appear hard but you must try things.

Fully understand your point John.

I did use the chart wizard but had no joy. I will have another look at the HELp again and may get back to this forum if I have no joy.

I have done my research for this:

MS Access for Dummies
Official MS Access Book
Forums
WWW

I think I might be just thick


Thanks for all your help

Fallyhag

Hope you had some luck with your charts.

Attached is a db I had a play with and you may find the report of some interest.

I shows you how to count, average and use percent in relation to your tick boxes. This may impress you boss enough so that you have time to learn charts. I must confess I hate charts in Access. If you have a look in the Northwind example there is a chart in there.

Hope you find the report helpful.


Regards