Countifs with unique values in access report
I am trying to create an expression to give me the count of PO + PO Line but I keep getting the wrong results. See some samples below in red. Shipped Orders Query Count PO PO Line Expr1 1 1 2 2225392 1 1 2225397 1 1 it should be 2 2225397 2 1 2225971 1 1 2225971 2 1 2225971 3 1 3060248 1 1 3060248 3 1 3060248 5 1 3060387 1 1 3060387 3 1 3061967 30 1 3061967 31 1 3061967 45 1 3062166 1 1 3062168 50 1 3062169 2 1 3062170 1 1 3062173 1 1 3062178 8 1 3062178 12 1 3062179 5 1 3062180 1 1 3062464 1 1 3062521 1 1 3062522 1 1 3062671 1 1 3062964 1 1 3063854 5 1 3063857 1 1 3063858 1 1 3063859 1 1 3063862 1 1 3063863 1 1 3063864 1 1 3063865 1 1 3063928 1 1 3063954 1 1 3063954 2 1 3063954 3 1 3063954 4 1 3063954 5 1 3063954 6 1 3063954 7 1 3063958 4 1 3063986 1 1 3064012 2 1 3064113 4 1 3064114 1 1 3064448 1 1 3065232 1 1 3065232 2 1 3065610 1 2