Calculate Assessment Status

[beachlife]

Hello, I think I am trying to something that should be quite easy, but I am just trying to make it difficult.

Members need to be trained in particular elements for example 30.1,30.2,30.3 and when they have done all of the elements, they are then qualified to sit the exam comp30. Or if they do 33.1,33.2,33.3,etc they qualified to sit the exam comp33.

What I would like to do is show on a report that if the person has completed all of the elements for comp30, a field will show at the bottom of the layout "needs to sit examination" if they have only completed a couple of elements it will show "has not completed all elements"

I am using a case calculation field that shows Case(element30.1 and element30.2 and element30.3 etc, "needs to sit examination";"has not completed all elements"). What it does is sees the first element in a record then puts in "needs to sit examination". Whereas i need it to look across all records for that member and if they have dones them all, then it will display "needs to sit examination"

Sorry this is so long winded. Couldn't think of a way to describe it.

Thanks in advance

[SlimJim]

I am trying to understand the structure of your records.

Are element30.1 etc the names of fields? which contain a 0 or a 1 depending on whether some element has been completed? From your description a member can have lots of records, what do the records contain in the way of fields?

I'm sure you are correct in assuming it should be easy but we need to know more about the explicit structure.

[RalphL]

It may have been long winded but not long enough to tell us anything about the database structure. Need to know more about where the data is stored and where is the report being generated. You can't tell us too much. A sample file is helpful.

[beachlife]

Hi again

Thank you for your quick replies.

The field name is elementid and the competency is competencyid

On entering a training record, I have created related value lists so that if you choose competency30 (this is a drop down), automatically then the element field lists all of the elements related to competency30 (as a drop down) and the user just clicks the relevent element eg 30.1

I have generated reports that will list via scripts all the usual things like competency achieved by element etc. But what I really also want to show is a report that shows:

Team Member: Smith

Has completed elements: 30.1,30.2,30.3 etc and if that team member has completed all of the elements for that competency then a note (or field) at the bottom of the page will say "needs to sit examination" or "has not completed all of the elements"

Clear as "mud", will attach if you need me to.

thanks again

[RalphL]

Send a sample file. The structure is sill unclear to me.