Compare and return 2 most recent dates



Hi,

I have a query that brings in multiple assessment dates (many different
assessments) for each child, including nulls if they haven't had a
certain assessment yet. Each child is 1 row. I need to return the most
recent date, and the one before that one for a new report. Any ideas? I
thought the Top Values property would work, but that only returns the
top 2 childIDs.

Thanks!
Lisa

.



Relevant Pages

  • Re: Why the police now have to ask teenage muggers: Do you eat chips?
    ... life tied to this database. ... Assessment) have been just as intrusive as the supposedly new powers. ... is now called the Child Protection Plan - although again, ... By far the biggest change is the fact that the Social Services, ...
    (uk.legal)
  • Re: Large arrears due to CSA delay - Im losing out here
    ... example of why this bloody mess should be shut down. ... My ex applied to the CSA over a year ago, the assessment has just been ... had I completed the forms I would have told them that I had a child ... contacted them to tell them about my child living with me - they said ...
    (uk.gov.agency.csa)
  • Re: Why the police now have to ask teenage muggers: Do you eat chips?
    ... life tied to this database. ... the only difference is that it will mean that each child will ... Assessment) have been just as intrusive as the supposedly new powers. ... is now called the Child Protection Plan - although again, ...
    (uk.legal)
  • Re: Paedophile check trials launched
    ... are so many other risks that could cause far worse harm to a child? ... allow our child to stay gets an H&S assessment to ensure that it ... Allowing those with children the right to ask the police for information already held by the police isn't going to cost very much. ... no significant cost at all. ...
    (uk.legal)
  • Computer based Kumon - check out www.jumpgrades.com
    ... Jumpgrades - Guiding each child to success! ... Assessment test determines child's starting level ... Children practice exercises modeled after the example ...
    (misc.kids)