Hi,
need help in summarizing a query based on the value on other field.
Attached the database for your reference. database contains:-
1. tblResponse - the data mainly get stored
2. tblresponse Query & tblresponseTimequery - contains data from 'tblresponse' & few additional columns of calculation.
3. QueryStatusTimecountreport - is developed based on the data under tblresponseTimequery
Column STATUS under tblresponseTimequery contains the types of activity
Column TIMEDiff calculates the time taken to perform the activity.
I need to generate query which needs to sum up the time in Timediff column basis on the status under each & every users.
Example:
User 1-New 2-Response 3-Closure 5-Reminder HariRam sumofTimeDiff sumofTimeDiff sumofTimeDiff sumofTimeDiff Assumption sumofTimeDiff sumofTimeDiff sumofTimeDiff sumofTimeDiff
I tried to generate the query using Dsum function with below calculation
Dsum("TimeDiff","TblResponsetimequery","Status=""1-New""") with the 'Total' as 'Expression' but shows an error as 'Incorrect data format.....'.
So, can someone please look into it and advise as how this query can be written to retrieve the information as required.
Thanks in advance.
Regards,
Harry