I want to retrieve rows of data showing for each employee one value for Amount based on the criteria set.
So as in the example, only one record for emp_id 12894 or 15950 should be shown.
However, when I run the query I obtain individual entries for the specific criteria but not one row that sums the unit charged or amount field.
I am not using any vb code. My sql statement in the querybuilder is not generating unique records by employee id and as such my gridview does not display what I need.
Any help will be appreciated.