Searching Multiple table names

[nikhil83]

Master table Schema - Index[Course,No of Nominations,No Attended,No of evaluation completions] : Its a summery table to capture numbers corresponding to course details.

Sub table Schema - Course name[Names of Nominated empl,Attended/Not,Evaluation score].
A sub table with same name as course name will be created for each entry in Index[Course] to capture course details.

Suppose I need to get Number of nominations for a course named MVC, in other words , i need to fill Index[No of Nominations] for the row Index[Course]=MVC . Then i need to search for table with Name MVC , Then count no of entries in MVC[Names of Nominated empl] and return that number to Index[No of Nominations] for the row Index[Course]=MVC .

Can you please let me know the formula to get this done....

 

[Somendra Misra]

Hi Nikhil,

See your file.

Regards,

 

[nikhil83]

Thanks a lot . This works fine....

 

[John()]

Hi was looking at your solution ... just wondering could you explain the ...... --ISTEXT .... what is the reason for the -- and why dose it not work without the two -- (understand the ISTEXT just not the --)

 

[Somendra Misra]

@John()

-- is a double negation operator. Basically ISTEXT will return TRUE & FALSE to convert them to 1 & 0 respectively, this is done. The same can be achieved by doing any mathematical operation on these logical values which will not alter them, like +0 or *1. But -- is faster than any other method, so I normally use it.

Regards,

 

[John()]

Thanks for that had seen The *1 but havent seen -- and it never occured to me thats what it was doing.