DSUM with multiple criteria including a Yes/No field
Advanced Beginner
Windows 7 64bit 
Access 2016
Not sure what I'm doing wrong here. This is returning a total sum of all "totalcost" fields and ignoring the criteria. It works without the And "[StaffEarmark]=TRUE" portion. Any help?
=DSum("[TotalCost]","[qryExpense_Actual]","[EventIDfk]=" & [EventsID] And "[StaffEarmark]=TRUE")
Competent At Times
Windows 10 Access 2013 64bit
Quote in the wrong place:
=DSum("[TotalCost]","[qryExpense_Actual]","[EventIDfk]=" & [EventsID] & " And [StaffEarmark]=TRUE")
Advanced Beginner
Windows 7 64bit Access 2016
Works like a charm. thanks.
Updating Field in tblA based on multiple criteria including date range
DSum with multiple criteria not resetting
Dlookup with multiple criteria including dates
Posting Permissions
Reply With Quote