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    
post Dec 6 2017, 04:44 PM

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    23rd March 2018 - 11:39 PM