crneophyte
Technical User
Hi.
I am trying to provide the most current record/value by state.
Sample
TP Zone Cls StartDate EndDate Value Condrec
A1 Fl MW 2/3/2004 10/26/2005 1.75 101
A1 Fl MW 10/27/2005 12/31/2006 1.30 123
Result should be the second line with value = 1.30
I tried Maximum ({table1.Codrec}, {table1.State}) but it gives me the first record it finds.
Any help is appreciated.
Thanks,
crneophyte
I am trying to provide the most current record/value by state.
Sample
TP Zone Cls StartDate EndDate Value Condrec
A1 Fl MW 2/3/2004 10/26/2005 1.75 101
A1 Fl MW 10/27/2005 12/31/2006 1.30 123
Result should be the second line with value = 1.30
I tried Maximum ({table1.Codrec}, {table1.State}) but it gives me the first record it finds.
Any help is appreciated.
Thanks,
crneophyte