shaunbch

Ah, that is brilliant, thank you! I didn't realise you could add a filter at the 'Select Data Fields' stage. Running beautifully now!

That is working better, thank you! Priority 1 is appearing first, which is helpful. However, I have added filters for FSM = Y, priority = 1, parental responsability = Y, and email = not null. The FSM filter is working, it's pulling back rows that fail the other filter rules: Any idea why?

I am running a report based on pupils on roll, which pulls back the emails for parents/carers. In the output, it always puts the priority 2 email first, and then the priority 1. I can't figure out a way to sort it so that priority 1 shows first - it doesn't offer up priority as a sort field, even though it's one of the fields I pull for the query. Is there a way?