What criteria would you use to pull up the latest date in a series of dates? Thanks.
D DSmith Dec 4, 2003 #1 What criteria would you use to pull up the latest date in a series of dates? Thanks.
D Dan S. Dec 4, 2003 #2 You should be able to use an aggregate function, and look for the Max record in the field. Just hit the Sigma button (looks like a weird E) to view the grouping, and select Max to retrieve the maximum (most recent) date in that field. HTH, Dan.
You should be able to use an aggregate function, and look for the Max record in the field. Just hit the Sigma button (looks like a weird E) to view the grouping, and select Max to retrieve the maximum (most recent) date in that field. HTH, Dan.
