Link to home
Start Free TrialLog in
Avatar of Ryan Simmons
Ryan Simmons

asked on

How can I use the Ms Access function DSUM in a manner similar to SUMIFS? Example Provided

If you look at the posted Excel example you will find a SUMIFS function that is deriving last week's number by using the store as the first criteria and the weekstartdate-7 as the second criteria. Is there a method where I can achieve the same results using the data in  columns A-C to accomplish what the function is doing in D?
Example.xls
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ryan Simmons
Ryan Simmons

ASKER

Good point. Ty!