Search results

  1. C

    Find Similar records in Two Tables

    Sooo The solution is the following Table1 has some names. Lets say john margaret etc etc . What i did is a created a query with the left function so i can check the first letters of the name i am interested in looking on table 2 SELECT Left([Jarred],4) AS Expr1 FROM Table1; For table 2 i...
  2. C

    Find Similar records in Two Tables

    Hey The Doc Man! Thank you for replying to my post! Well I ll maybe do that because I ve been looking for the same thing and cant find it nowhere. Tommorow I ll go back to the office and check something that i have on my mind. It has to do with left function and left join! Will post if it works!
  3. C

    Find Similar records in Two Tables

    Hello! I see it is solved but which was the solution ? ( 9 years after last post :p )
  4. C

    Appending Query Multiplies Data

    Thank you! I will go ahead and check it right away! :)
  5. C

    Appending Query Multiplies Data

    That is to be done randomly ( and i will put some more criteria on the way later!) That's why i made the query random distribution so TableC can get the IDS from there in a random sequence along with the duties and allocate them randomly to each other! For example if i am to populate TABLEC...
  6. C

    Appending Query Multiplies Data

    Here it is in english! Thanks in Advance
  7. C

    Appending Query Multiplies Data

    Wrong ZIp Here is the right one Sorry!
  8. C

    Appending Query Multiplies Data

    There are 182 duties ( Not every duty is needed each day) My department is responsible for all the courts. That's why there are so many duties. For example in one court depending on the case and the prisoners needed to be transferred i may allocate one or two or even ten officers. That will...
  9. C

    Appending Query Multiplies Data

    Right Away sorry for the Delay ΠΡΟΣΩΠΙΚΟ is TABLEA (consists of the details of "all" the police officers) ΟΜΑΔΕΣ is TABLEB ( which consist of all the duties probably needed to be assigned along with number of officers required for each duty (could be one or could be 10. That depends)...
  10. C

    Appending Query Multiplies Data

    Hello! I am trying to build a database which will consist of 3 tables and many more Queries which will randomly allocate police officers to the required , for the day, duties. I am in a police department in Athens Greece which has more than 250 officers and currently there are 8 people trying...
  11. C

    Greetings from Greece!

    Hello to all users from Sunny Greece. #UnfortunatelyAthensNotGreekIslands #Soon
Top Bottom