UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Sum Based On Criteria, Access 2007    
 
   
ThankYou1
post Dec 6 2017, 04:44 PM
Post#1



Posts: 25
Joined: 19-August 10



See attached. I need to write a query that has a total for "Unique PO Count" and "Lines" if the Method field indicates anything other than EDX. So ideally, I'd have 2 records for each day one with totals for EDX and with with totals for all others - where all others are combined. 7/2 for example would be for EDX unique po count = 27, Lines = 227, and Amt = 7,437 and then Other Unique PO count = 42, Lines = 2268, and Amt = 47,384. Hope that's enough info. Thanks.
Attached File(s)
Attached File  sample.pdf ( 100.02K )Number of downloads: 16
 
Go to the top of the page
 

Posts in this topic



Custom Search
RSSSearch   Top   Lo-Fi    18th December 2017 - 05:20 PM