I am building a report for a fire department that consists of some data about the hydrant testing. I want the list to show each of the hydrants and only there last test date and results.
This is the current formula i am using, but when I put this in the detail section it retuens all the test dates for each of the hydrants.
if Date({FlowTest.DATE}) <> date(1900,01,01) then totext(Date({FlowTest.DATE})) else ''
I only want it to return the most recent test date and data
Any help greatly appreciated