Good morning.
You guys/gals have been most helpful to me as I try and setup my database.
I am trying to count a field, but only count the first character of the values.
Example:
The values in my field are entered like:
3, (II,C)
3, (III,B)
5, (IV,C)
5, (IV,D)
I would like my query to count just the first character, in this example, '3' and '5', so the count return would be 2x '3' and 2x '5' without including anything after the first character.
Mark