I am having trouble running a sum in a query for one particular column. The "count" works fine, it just won't sum. I'm guessing it isn't reading it as a number properly, correct?
How can I fix the problem? It comes from a query that runs an expression that is:
BookedTrue: Abs(Sum([Booked]=True And [RecordedMessage]=[qryWhosComputer]![Last]))
It is that value that isn't properly allowing me to sum. Thanks!