Hi DBlank
I have grouped on Further Action and the variations of "Initial Assessment" are all grouped together - this includes variations such as "initial assessment" and "Initial assessment".
Within the group, they have been sorted in a way that groups all of the matching case variations together even though this is not how it should be sorting as I have specified to sort by person id. It is sorting by person id after sorting by case sensitivity.
Even though the grouping of Further Action has combined the various cases into 1 group, the record selection criteria when used, is still only showing records which match the case of the data I have entered. I appreciate that using the lowercase function is a possible workaround but ideally I need to figure out why this has happened.
I'm sure this has only just started happening which makes me wonder if a setting on the database has been changed.
Hope that made sense
Chris