Search results for query: *

Hi I have an Employee table in Access database. It has fields Empno, EmpId, DeptNo, Loc, Salary , Manager_id It has close to 88,000 records in it I would like to query the data with a recordset and later I would like to dump all the data into a Note pad Each field needs to be separated by...

I am using Access 2003 database. I have an employee table with fields Empno, EmpName, Day_worked fields Day_worked have values like 'Sunday', 'Monday', Tuesday'..etc I am trying to parameterized query a table like Select * from Employees where Day_worked In ([P1]) Here P1 is a parameter...

I have an xml file ( C:\Emp.Xml) with employee information in it It has data with empoyee_id , employee_name, location and salary information These are the columns and the data is in xml format Emp_id, Emp_name, Loc, Sal The number of records in the xml file is varying I would like to read...

Hi I have a form field in MS Word 2003 . The default background color is grey color How do I programmatically make to back ground color of the form field to white The name of the form field is FField1. There are other form fields in the Active document also. But I want only FField1...

I have a 3 form fields in MS Word 2003 They are in 3 columns of a table in the Word Document Each form field has values Employee_id, Employee_name and Salary Form Field1 in Table Column1 is supposed to contain any number of Employee_ids Form Field2 in Table Column2 is supposed to contain...

I have MS Access 2000 on my machine . I have around 40 applications running in Access 2000 on my machine My client has sent me an MS Access 2003 mdb file I am unable to open that file from MS Access 2000 I am getting an error that my database is of a lower version and needs to be upgraded ...

I have a table (PROJECT) which maintains yearly expenses information. It has the expenses for an year and also the cumulative expenses till that year . The table may or may not have data for all the years in a consecutive manner The PROJECT table data is like Project_id Year Yr_Exp...

I have an Excel workbook (WBK), which has two sheets ( Sheet1 and Sheet2 ) Sheet1 has all the countries and their corresponding capitals in column A and Column B respectively. There are about 180 rows Sheet2 has only few countries ( about 100 ) and has country names and capitals in Column A and...

I am having two tables . A Master table and a detail table The master table is a HOLIDAY table which has a list of all the holidays in the company. The field is HOLIDAY_DATE. There is a detail table is HOLIDAY_PROCESS table which contains the overtime information worked in the holidays . The...

I have a Expenses table. It maintains the daily expenses in US Dollars of various units of the company. The structure of the table is Dept_Id Date Month Year Expense The data looks like Dept_id Date Month Year Expense --------------------------------------------------...

I have an employee table with Employee names All the Employees are supposed to end with a Full Stop (.) The data should be like Empno Empname ----------------------- 101 John Williams. 102 Tracy Roberts. 103 Alice Hilton 104 Joseph Fowler. But...

Hi I have a employee table with Empno and Empname The Empname has all Employee names like John Smith, Robert Jones Alice Williams .....etc However , The names are preceeded by " and the Empnames are looking like "John Smith "Robert Jones "Alice Williams "Keith Fowler How do I eliminate...

I have an ITEMS table. It maintains the record of all items which are in inventory. The columns in the table are Item_No, Time_Processed, Item_status. All items come in a queue and get processed within a minute So the Item_Status of items change from "Processing" to "Completed" Both these...

I have a worksheet with employee data. It has only one column which has employee ids All employee ids are in one column , one row after the other . However , there are some blank cells in between the employee ids. I would like to permanently delete those empty rows There are exactly 960 rows...

I have excel sheet with Employee names data in it separated by semi colons ( ; ) . I need to split those Employee names into individual Employee names The data in Worksheet1 in column1 is like this Bob; Mattew;Roger -------> ( row 1 ) Terrie; Steve; Adams -------> ( row 2 ) Victor...

I have an Employee table which has a field called " Employee_list " The structure is Deptno Deptname Employee_List This field has all the employee ids working a specific department stored in it separated by commas . The data in Employee_list field is like 101 , 102, 103, 104 ...etc...

Hi I am trying to create a Materialized View based on a Normal View for Complete Refresh in Oracle 9.2.0.6 The normal view is Employee_V CREATE MATERIALIZED VIEW Employee_MV AS SELECT * FROM Employee_V This works perfectly well in Oracle 9.2.0.6. But the Materialized View Creation Fails in...

Hi I have an employee_summary view which is based on multiple sub queries and complex joins. I have around 15 tables which are involved in the creation of the view The view "Employee_Summary" works fine and the data is correct Can I create a Materialized view(MV_Employee_Summary) in Oracle 8...

Hi I have an " employee " table with empno, empname , deptno, deptname fields. However in the employee table , all employees have deptnos , but not all of them have deptnames There is a " department_backup " table with deptno and deptname . ( This table is not same as department table )...

Hi I have an employee table (EMPLOYEE) which has employee start date(ST_DT) and employee end date(END_DT) I need to calculate the employee duration for each employee which is End Date - Start date There are some records which have blank start dates There are some records which have...