R
Rick Preiss
Joe-
Just create a "group by" query with the Num and Date
fields. Then, under the date field choose max in the
drop down "group by" box. The result will be only the
latest date. (I assume your date field is typed as a
date/time field.)
Rick
Just create a "group by" query with the Num and Date
fields. Then, under the date field choose max in the
drop down "group by" box. The result will be only the
latest date. (I assume your date field is typed as a
date/time field.)
Rick