Access Sumifs

[mahmed1]

Hi

how can I achieve this same result in Access...

essentially i want to add up the AHT column and divide the totals column only if the date is > #01/01/2020# AND < #01/02/2020# AND TYPE = ‘YELLOW’ and put this result in Weighted column

i tried this with no luck

Select Date_, Type, Total, Sum[AHT Colum]/[Total] as Weighted Column
WHERE Date_ > #01/01/2020# AND Date_< #01/02/2020# AND Type = ‘YELLOW’
Group by Date_, Type, Total

 

[JonXL]

What is the name of your table?

 

[mahmed1]

The table is called tbl_RawData_Rolling

 

[JonXL]

This?

SELECT 
   Date_, 
   Type, 
   Total, 
   Sum([AHT Colum])/Sum([Total]) AS [Weighted Column]
FROM
   tbl_RawData_Rolling
WHERE 
   Date_ > #01/01/2020# AND Date_ < #01/02/2020# AND Type = ‘YELLOW’
GROUP BY 
   Date_, 
   Type, 
   Total

 

[xenou]

If you still have trouble post a few rows of sample data and expected result with that data.

 

[mahmed1]

That worked
Thank you so much