Search results

  1. I

    Query to Json

    Hi, I have attached a database that can generate Json from a Query data. But I am trying to get Json output from a query in a specific format. (Expected Json format attached) My Database contains 3 tables 1.Bill - Contains Invoice no. and customer details 2.BillProducts - Contains products...
  2. I

    Solved Leave List as per Date Range

    I have a Table "Leave" containing data as below: LeaveAppliedOn........LeaveAppliedTill........EmployeeName 03-Jul-19.................06-Jul-19.................A 04-Jul-19.................05-Jul-19.................B 05-Jul-19.................08-Jul-19.................C...
  3. I

    Attendence In/Out Arrange

    I have Data in "Log" Table as.. Date|EnNo (EmployeeID)|Time (Punch Time)|Direction Now i want those data in a way... Date|EnNo|InPunch|OutPunch Mdb file with data attached.
Top Bottom