URGENT HELP NEEDED - PLEASE!!! 1

[fallyhag]

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

 

[Eupher]

Create a text field in the report footer of your report. Set its format to "Percent" and choose how many decimal places of precision you prefer. For the control source of the field, enter this (all on one line):

=DCount("[Passed Test?]","tblMyTable","[Passed Test?] = True")/DCount("[Surname]","tblMyTable")

...where tblMyTable is the name of your table.

HTH...

Ken S.

 

[fallyhag]

After a lot of experimenting I seem to have got it to do the percentage. Thanks.

With regards to:

=DCount("[Passed Test?]","tblMyTable","[Passed Test?] = True&quot/DCount("[Surname]","tblMyTable&quot

Do you have the time to explain this "expression?" just I know for the future or want to modify it?

I would be very grateful.

Thanks again

Fallyhag

 

[Eupher]

You're quite welcome. The DCount() function counts records in a given domain (i.e. table or query) based on whatever criteria you specify. The generic form of the expression is DCount("[field to count]", "table or query name that holds field to count", "search criteria&quot. The search criteria is optional, and is like the WHERE clause(s) in a query but without the word "WHERE". So the first part of the expression in my example basically said "count all the [Passed Test?] fields in tblMyTable where the value of [Passed Test?] is True". The 2nd half of the expression says "count all the [Surname] fields in tblMyTable". And the forward slash "/" is the division operator. So the whole expression evaluates to "the value that goes in this box is the number derived from the first DCount expression divided by the number derived from the second DCount expression" or, put another way "= X/Y".

HTH...

Ken S.

 

[fallyhag]

Your helpfulness and patience is greatly appreciated.

Thank you!

Fallyhag