troubleshooting Question

How do I get a sum of two returned rows in a Access query?

Avatar of Cole100
Cole100Flag for United States of America asked on
Microsoft AccessSQL
4 Comments1 Solution11 ViewsLast Modified:
I am working in MS Access as my SQL knowledge is limited. When I pull Method of Payment I need the CASH and CHANGE to be returned as a SUM. In this example: CASH 312.89 and CHANGE 52.93 I would like it to just return the result as CASH = $259.96 along with all the other MOP's. I do not want to see the change line.

Is something like this possible? Thanks for any insight you can provide.

SELECT dds_Daily_MOP_Tb.Store_Number, dds_Daily_MOP_Tb.Operations_Day, dds_Daily_MOP_Tb.MOP, dds_Daily_MOP_Tb.MOP_Amount
FROM dds_Daily_MOP_Tb
WHERE (((dds_Daily_MOP_Tb.Store_Number)=2322) AND ((dds_Daily_MOP_Tb.Operations_Day)=Date()-1));
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros