Search results

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...

@arnelgp : Thank you so much! The demo file that you have sent is working as per the requirements and, is there any possibility of providing the capability of updating the content from the same form? Do I need to convert that into UPDATE Table? Also, I tried using...

I have a set of Skills in a Skills Table named "tbl_Skill_Groups". And I have Team Details in a table called "TMT_TeamDetails". There is a Junction table created (tbl_TeamSkills_Junction") to track the scores of each Employee for each Skill. Now I want to create a form where I would select the...

Thank you :)

Yes @arnelgp

Any help/suggestions on this, please...