Hi,
This is probably going to be pretty basic, but...
I have a query that returns each record with three fields:
A stable identifier (StableID)
Text string with multiple varieties for each StableID (VariableText)
A numeric count of how many times each VariableText is associated with each StableID (TotalCount)
I'd like to create another query that lists each StableID only once with the VariableText with the highest count. That's the reason for the count, it's not valuable otherwise. What function would I use for that?
Basically the count is the first half of a MODE function, which Access doesn't appear to have. If I could do it all in one query that would work too. If this doesn't work out I'll just switch over to VBA.
Thanks in advance!
This is probably going to be pretty basic, but...
I have a query that returns each record with three fields:
A stable identifier (StableID)
Text string with multiple varieties for each StableID (VariableText)
A numeric count of how many times each VariableText is associated with each StableID (TotalCount)
I'd like to create another query that lists each StableID only once with the VariableText with the highest count. That's the reason for the count, it's not valuable otherwise. What function would I use for that?
Basically the count is the first half of a MODE function, which Access doesn't appear to have. If I could do it all in one query that would work too. If this doesn't work out I'll just switch over to VBA.
Thanks in advance!