Countifs with unique values in access report

Copper Contributor

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

112
222539211
222539711 it should be 2
222539721
222597111
222597121
222597131
306024811
306024831
306024851
306038711
306038731
3061967301
3061967311
3061967451
306216611
3062168501
306216921
306217011
306217311
306217881
3062178121
306217951
306218011
306246411
306252111
306252211
306267111
306296411
306385451
306385711
306385811
306385911
306386211
306386311
306386411
306386511
306392811
306395411
306395421
306395431
306395441
306395451
306395461
306395471
306395841
306398611
306401221
306411341
306411411
306444811
306523211
306523221
306561012

 

2 Replies

@FJMSalgueiro 

Could you attach a small sample database demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Showing us a supposedly erroneous result without explaining how you calculated it and with no supporting source data gives us nothing to work with. Either provide a sample accdb or provide the source data (as it actually appears in the table) and the calculation method.