I need to do countifs and sumifs in access and cannot find a solution.
I need to count how many times a value in one field of one table appears in the field of another table. I've tried several things but keep getting errors. What I am trying to do is exactly what a COUNTIF does in Excel but in Access.
How many times does the order number in Table 1, Order No. field appear in Table 2 Order No. field?
Table 1
Order No. Order Count
ABCD 3
1234 2
EFGH 1
5678 2
IHJK 4
91011 5
Table 2
Order Number
ABCD
ABCD
ABCD
1234
1234
EFGH
5678
5678
IHJK
IHJK
IHJK
IHJK
91011
91011
91011
91011
91011
Bookmarks