only show Maximum value

[DJBummy]

Hello all
I have 5 different reservoirs and keep track of the rainfall at all 5.
I want to total all five together and then only show the maximum value on a yearly basis. But I also want to include the individual fields for the reservoirs in the record.
I hope I'm making sense.

DJ

 

[DJBummy]

Thanks Pat.
I have an additional question.
The reservoirs are five different tables (not my design) and I created a query including all five tables and added a expression that Sum the rainfall fields.
My question is can I use your suggestion using the expression as the maximum value