Recent content by shacdactvm

  1. S

    Query as a spreadsheet model

    A Sample db is attached for your reference. please check
  2. S

    Query as a spreadsheet model

    @stopher When I followed you, I am getting "Invalid precision for decimal data type" message. please check attached query builder screenshot and please guide me to do the same. thanks
  3. S

    Query as a spreadsheet model

    BTW, How can I show an average column to the right of this query as below. EG: EmpId-----Name --------2011-------2012--------2013---------2014---AVG 123456------ABC----------9.2---------8.0----------8.5-----------7.6----8.33...
  4. S

    Query as a spreadsheet model

    @Frothingslosh Thanks a lot.....I done it :)
  5. 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...
  6. 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...
  7. S

    Running count over a group in Query

    Million Thanks CJ_London. Its awesome..
  8. 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...
See more
Top Bottom