Search results

  1. I

    Query to Json

    Finally done it bro. Cheers!!
  2. I

    Query to Json

    Umm.. that's disappointing. Well i must try alternative way and hope to get a solution to this in future. Thanks bro.
  3. I

    Query to Json

    I already tried with this flat query but didnt get desired result. I exported this flat query data to Excel and covnverted to JSON with online converter. This is what i got.. [...
  4. I

    Query to Json

    Thanks for reply. Yes there are few mistakes in the expected json file as i typed it manually. So can you alter the query structure through which i can get the desired CSV file? This is going to be regular event, infact this process will be used to generate e-invoice from goverment prortal. We...
  5. I

    Query to Json

    Yes please have a look. Attachment contains a .mdb file and a .txt file as json example.
  6. I

    Query to Json

    Yes the attached database can convert query to json.
  7. 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...
  8. I

    Solved Leave List as per Date Range

    LeaveAppliedOn and LeaveAppliedTill is DateRange of Leave given to EmployeeName in Table "Leave" LeaveDate and EmployeeName is to be Generated in query From data in "Leave" Table.. Like: LeaveDate........EmployeeName 3-Jul-19...........A 4-Jul-19...........A 5-Jul-19...........A...
  9. I

    Solved Leave List as per Date Range

    some data missed on previous post.. here it is again: 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...
  10. 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...
  11. I

    Attendence In/Out Arrange

    Bravo... This is perfectly the right 1... Thanks a lot
  12. I

    Attendence In/Out Arrange

    I check bro but unfortunately its not happening. Inlogs are repeating in ur query. Thanks.
  13. I

    Attendence In/Out Arrange

    Tried the Query In Data Table, for Date 12-07-2019 & EnNo(Punch ID) 1 i have 31 times In & Out record like: Date EnNo Time Direction 12-07-2019 1 2.22.00 PM IN 12-07-2019 1 2.29.19 PM OUT 12-07-2019 1 2.30.25 PM IN 12-07-2019 1 2.30.29 PM OUT 12-07-2019 1 2.30.33 PM IN...
  14. I

    Attendence In/Out Arrange

    Thanks for responding.
  15. 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