Using DCount on summarized data
Posted on 2011-10-20
I have a table that has the following columns: ID, Rider, RiderSub, Date, Class.
ID is a primary Key. For each date, each Rider/RiderSub may have many classes.
1 SMITH A 5/1/11 51
2 SMITH A 5/1/11 70
3 SMITH A 5/1/11 82
4 SMITH B 5/1/11 81
5 DOUG L 5/1/11 51
6 SMITH A 6/3/11 51
7 SMITH A 6/3/11 61
I need to know how many days each Rider/RiderSub combination participated.
For the example above, I need to see
SMITH A 2
SMITH B 1
DOUG L 1
I can't figure out what I'm doing wrong. I keep getting the number of classes rather than the number of dates no matter how I go about it.
I'm using a DCount because it's going on a report, I could possibly use a query if necessary.
If I can just get pointed in the right direction, I'd appreciate it.