GinaWhipp - thanks. I've tried using a 2nd query to find the max, but changing the Total option to Max changes nothing in the query. It still returns every entry even when multiple entries have the same reference number.
gblack - thanks. I'll try and explain it better. Each case has a unique...