Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Atalla

    Displaying all dates between date range

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

    Displaying all dates between date range

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

    Displaying all dates between date range

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

    Number increment in an Append query

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

    Number increment in an Append query

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

    Number increment in an Append query

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

    Number increment in an Append query

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

    Number increment in an Append query

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

    Number increment in an Append query

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

    Number increment in an Append query

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

    Rounding Problems

    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"))
  12. Atalla

    Multiple recipient

    Thanks again Ken for your help.
  13. Atalla

    Multiple recipient

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

    Multiple recipient

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

    Multiple list box

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

    Multiple list box

    Hi all, This question has been addressed before but unfortunately, all the solutions provided apply only to Single user environment. Even the ones at Microsoft.com Briefly, I have 3 tables: tblAgent: AgentID, FirstName, LastName tblLanguages: LangID - Data Type is Text...

Part and Inventory Search

Back
Top