Forum Discussion
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 |
- 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.
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?
