Ad Hoc - Status U DAs in Street Name Order

Status U DAs in Street Name order

LIST AGT_TRANS WITH STATUS = "U" AND WITH CLOSE_PERIOD BETWEEN 201001 AND 201012 BY PROPERTY STATUS PROPERTY STREET_NO NAME_L DATE_CLOSED TYPE

Replace the bold dates with the four digit year and the two digit month that that you want the report to start and finish in.