Dear All,
How do I translate SUMIFS statements from Excel to Access?
I currently have this SUMIFS statement in Excel:
=SUMIF(DataOrder!$A$2:$A$8;CustomerData!A2;DataOrder!$B$2:$B$8)
How do I structure a query to accomplish what the SUMIFS statement accomplished?
Please help how to creat the Query (Totaal Refund) the same as in EXCEL in to MS access ( zie attachment Excel en Ms access)
Thank you in advance
Kirana Wayan
Bookmarks