Where do you want to display the information, on a form? a report? in the query itself?
If you have a summary query that shows the information you want
let's say something like:
Code:
PersonID Cases100
1 5
2 7
You could just add this to your query:
CaseSentence: [cases100] & " cases have addition fees greater than 100"
domain functions (dsum, dcount, dlookup) can be useful but on large databases they an be very inefficient and I'd try to stay away from them if your database has the potential to be quite large.