Suppressing Dates

[jlp118]

I created a report that shows every customer that ever bought and every product that they bought on every date. I have the dates in ascending order. What I need is just the most recent date and to suppress every other date until it shows the next product. Then I need to show the most recent date for that product and so on and so on. Please help!!!

Thanks,
Jeff

 

[darwin101]

if your grouping by product, try to use the max function on the dates, then move the max date up into the group by field. suppress the other dates.

HTH ;-)

 

[jlp118]

Forgive me for sounding ignorant, but how do you use the max funcion?