Recent content by Atalla

May be I didn't explain myself. The employee table contain all kinds of information, e.g., full time or part time, team manager, etc.. and same employee has/could have more than one record and every record contain the StartDate and EndDate of that particular change that occur, e.g., employee...

Thanks GingerR and sanders720, but the solutions do not really help my case. I'll try some other solution but if anyone comes up with a solution, please let me know. Thanks. Atalla

Hi all, I have 2 fields in a table -StartDate and EndDate-. I would like to create a query to display all dates between those 2 dates range. Example, an employee was sick between October 1st and October 15th, thus, StartDate = 10/01/04 EndDate = 10/15/04 Therefore, only one record exists for...

My God, all this to append an AutoNumber field. Well, guess what, everything works perfectly. I don't know how to thank you, I would never have thought of this solution, besides I am not that good with Access. I made some modifications, like for instance, in the last query (Append), I removed...

I understood your plan but I don't know if it will work. Below is the SQL for the original query (qryNewFte) that calculates the New ratio. I guess the only field you're interested in this code is the field "NewFte". SELECT CCADMIN_CC_EMPLOYEE.CSR_AGENT_NO, tblAdpPayroll.FileNumber...

I have 3 criterias: 1) END_DATE: Is Null 2) END_REASON: Is Null For those 2 criterias, it selects only Active employees who are still with the company, i.e., not terminated/resigned. 3) There is a field that's connected to a query containing a number ratio. If new ratio in that query is not...

Appreciate very much your help. Below are the tables name: Table1: Name: CCADMIN_CC_EMPLOYEE Primary key: CSR_AGENT_NO Table2: Name: CCADMIN_WORK_HISTORY Primary key: WORK_HISTORY_ID Foreign key: CSR_AGENT_NO All names are in upper case letters...

I absolutely agree with you, but the thing is, well, it's a long story and I am trying not to go into too much details. The tables are on a server and DBA (database adminstrators) were the ones in charge of designing it in Oracle and doing the Insert/Update and incrementing the records. I...

Hi Bob, Thanks for replying. The primary key in both tables are not AutoNumber fields, they are Number fields. To explain a little further, Table1 contains all employees related info; FirstName, LastName, phone number, telephoneID, salesID, supervisor name. Now, the way my program works is that...

Hi all, How to increment an ID field with "Number" as data type in an Append query? That is, inserting fields from Table1 into Table2, relationship is 1 to many. The link between both tables is that primary key of Table1(ID)is a foreign key in Table2. Table2 has its own primary key...

I am using a two fields calculation as an example. You can use the below formula to round up the value to 2 decimal places. NewFieldName: CDbl(Format([Field1]/[Field2],"#.0"))

Thanks again Ken for your help.

Hi Ken, Thank you very much for your reply, the code works fine + I added more code to include FirstName and LastName in the email. Another thing, it's not urgent, but I've tried to apply the same code to another combobox on my form. The combobox contains all employees, but only LastName...

Hi, I have a ComboBox (languages), ListBox (employees), Command Button (Select) and a Command Button (email). I choose a language in the ComboBox, click Select and then displays all Employees who speak that language in the listbox. When the listbox MultiSelect property is set to...

Thank you very much for your reply. You clearly understood my question. There is no problem to iterate through the rows but the problem is AgentID field is not part of the list boxes, but rather a text box on the main form and thus saving the AgentID field in the table is my opstacle. In...