Return value based on date

• kj.nguyen

  Grasshopper

  Points: 11

  More actions

  April 17, 2015 at 11:15 am

  #317529

  Hello All,

  I have a simple report attached. It is grouped by staff name. For the rate at the group header I want to return the value with most recent date (max date). For example, Dawn's rate should be 120.00, Carol's rate should be 100.00, and Ashley's rate should be 150.00. Thank you in advance.

  KJN

• sql Sarah

  SSCrazy

  Points: 2081

  More actions

  April 22, 2015 at 8:39 am

  #1792758

  What happens if you move the rate field up into the header? It should show the last one.