Recent content by mrk777

NULL values must be analyzed from 3 fields Readiness Status; Time Frame; Criticality_Reason, not from only a single field. I have mentioned the example data above for your reference. Thank you!

I have a table of Employee Details and I would like to identify the count of a few fields combinedly and identify the count to get the progress % at a Function level Emp Table: Emp ID Function ID Readiness Status Time Frame Criticality_Reason 1 2 Change Likely within 1 Year Expert 2 2...

So you are saying that it’s better to project the Table directly instead of cross-tab query? I tried different ways to get the data as per the requirements, but I couldn’t do it!! Can you please suggest/help?

Hi Team! I have an issue with Cross Tab query and following are the tables and query structure I followed: Table: I useed Cross-Tab query to get the results based on Time_Frame Count which resulted as follows: Apart from 3 time frame categories you see on the top, there are 2 more ( 3 - 4...

Understood!! I will try to change it accordingly, Thank you!!

Yes, I have used the Like operator for one field and the Nz function for one of the fields, which seems to be working fine!!

Hi @Pat Hartman, I'm at a beginner level and trying to learn deeper into the concepts. Sure, I would revamp the code and relationships wherever possible. Thank you!! :)

I have applied the concepts from the link you have provided and that seems to work well, thank you!!

Hi, I have a query that has the Rewards Details (qry_R&R) and I have created an Unbounded Form where I linked that query (qry_R&R). Now I would like to filter the results based on Function/Department and then with the Team Member Name. I tried the query as mentioned in the below method: I...

Thank you so much @arnelgp, calculations are so accurate as per the requirements. One quick question: can I remove the option "Default value = 0" in the "Targets" table and leave it blank, if yes, will that affect the above-created calculations? The reason why I have asked is that for some of...

Because for Skill 3, we have the target, but the current score is 0 and for Skill 5, we have obtained the Current score even though we have no target, so I just considered it, I have mentioned them just to showcase the example.

The calculation is going wrong somewhere. I have provided a brief snapshot of how the calculations need to be: Skill Name Current Score Target Score Skill 1 3 4 Skill 2 0 0 Skill 3 0 3 Skill 4 2 2 Skill 5 3 0 Now Calculation goes as below: 1. Current Skill Capability %...

Apologies for the delayed response @arnelgp, I was in a place where I could not access my system, And it took me a bit longer to understand how you have connected the tables, and finally I was able to make it after observing your options that are modified in Indexes. It is working as per the...

Hi @arnelgp: I have found a small issue while adding the new team member records. When any new team member data has been added, it will automatically add to the Ztbl_EmpSkill table, but if there are any modifications made to the existing Team member details (like a change in the Function ID or...

Hi @arnelgp: I tried converting the query to an update query, but it is throwing an error and not updating the records in the Form. Also, I have tried a similar type of solution that you have provided to other criteria but I could not able to get it. Following is the scenario: We do have...