We need a modification to resolve problems with a query script.
The script is attached.
1. Correct Duration with a special Calculation of the Start Time / End Time
The start field is the lowest date in conjunction with a unique call number
The end field ist the highest date in conjunction with a unique call number
The duration is the difference between the lowest date and the highest date of a unique call.
ATTENTION: There is no other way than calculate the maximum and minimum to identify the start and end time.
This actually completly wrong in the script.
2. Correct Fields
The description must be in the correct field
See picture (attached).
11 freelancers are bidding on average $153 for this job
Hi, after going through the table structure, it seems i can fix the problem.i need the scripts along with tables related to build the query. Lets start. Cheers Sagar
Hello, i have a question: The problem is that if the calculation return no value the columns are misplaced? If so, it is a VERY simple thing to fix. Posted the bid to get your answer... i can help anyway. Thanks