Search results

  1. S

    Query as a spreadsheet model

    Hello there, I want to create one query as follows. I have one query 'ManpowerMain' and a table 'Assesment'. I want to join this. Both having a primary key 'EmpID'. Assesment Table Structure ID EmpID AYear Mark Grading 1 123456 12-31-2013 9.20 Outstanding 2 123456...
  2. S

    Create APPLICATION_ID automatically by continuing number

    I am using an attendance management system with a DB in Access. Now I want to create APPLICATION_ID automatically by continuing number. For example, I have a table called "LEAVE_APPLICATION" and the structure is below: EmpID Leave_Type_ID APPLICATION_ID 00360 2 1 00360 2 2...
  3. S

    Running count over a group in Query

    Dear All, I have an access query named "leaveapp" and I want a running count as below: EmpID TypeID 360 1 360 1 360 14 360 14 360 8 1390 8 1390 8 1390 14 1390 14 1390 1 and i need a column in the right with running count...
Top Bottom