MS Access - SQL Query Date wise with selection of column summarized value

[kawalkar.hemant]

Below is my source Data





by using below query I can get summarized data for '17-09-2016'
SQL Query :-
SELECT key_val.A, key_val.B, key_val.C, key_val.D, Sum(IIf(key_val.Store_date=#9/17/2016#,key_val.Val,0)) AS [17-09-2016]
FROM key_val
GROUP BY key_val.A, key_val.B, key_val.C, key_val.D;

but I am looking output suppose to look like this way.



Specifically= I need summarized data for column a,b,c and for '17-09-2016' dateIn excel we will apply sumifs formula to get desired output but in Access - SQL I am not getting how to form the query to get the same data.

Can any one assist me how to achieve above result by using Access Query?

Specifically= I need summarized data for column a,b,c and for '17-09-2016' date

[CJ_London]

first, your data looks like an excel spreadsheet and not a table. Excel and Access work in completely different ways and store their data differently. So any querybased on 'excel' style data will be much more complex and possibly not doable.

it would help if you used real names, or at least more meaningful ones and your description matched the data. Are A, B C etc store names or product names perhaps? Why does your code have columns A-D but your text only refer to a-c? why does the second row of your result show a value of 34 and also have the last two rows when the filter is supposed to be 17-09-2016 and your data shows later dates?

Remember we know nothing of your business and can only go by what your write - which at the moment raises more questions than it answers.

Suggest explain in simple English what you are trying to do, what the data means and what the result is you require.