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..
[...
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...
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...
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...
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...
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...
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...
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.