designation

how to calculate percent rank for employee salary with designation and no of year experienc as condition

Hi, I am using below query to get details. SELECT Designation, Count(Designation) AS Total FROM Combine WHERE MyDate = #5/7/2018# GROUP BY Designation ORDER BY Count(Designation); This query gives me number of people for each designation from the table. How can get sum of number of people...

Hi, I am using below query to get details from database. SELECT Designation, MyDate, Count(Designation) AS MyCount FROM Combine WHERE Designation = 'Senior Dummy Manager' GROUP BY Designation, MyDate ORDER BY Count(MyDate); However, whenever I click on query, I get a pop-up as...

Hi, I am writing below query to get distinct of designation from a table. How do I get count for each designation by editing this query. For example, one of the field is 'Manager' and count for managers is 70. How to get count 70 for manager by editing this query. SELECT DISTINCT Designation...

Hello, Need help with the following - I have the following information in one sheet <Sheet1> in Column A. This list is very long (1000s of names). I need this information to move to <Sheet2> in this format - Name (Column A), Designation (Column B), Company Name (Column C). The <Useless Info>...

Hi to all, i want to know since when a staff is at the current Designation? any guidance/tip,,.,.,regards. Pic for the issue https://imgur.com/a/T7ULe OR https://www.photobox.co.uk/my/photo/full?photo_id=500671381803

Hi All, This post will help me understand the use of offset and resize hopefully. I have a range ("C8:C31") containing names and designations of employees.For first emp the name is in the range "C8" & and designation in Range"C10" and it goes on till C31 for other employees.This means that one...

Hi everyone, I have number of cells having complete detail of an employee in one cell (for each) need to split by heading, data is like; Designation: Executive, ID card: 0011, DOJ: 25-May-2016 How can I seperate the data? As I need designation in seperate column, Executive in seperate and so on...

I have the excel data which includes Outlook email IDs. I wanted to retrieve details from outlook like Designation, Office Location and Office phone number into excel. Excel data: <tbody> Email IDs Office Location Designation Office Phone Number xyz@xy.com xyl@xy.com </tbody>...