Max or Last

Hello.

I have a database that have a control called case. Each case have multiple
events. These events have date stamp on them.

What I am trying to find out is how can I show only the most recent event on
each case?

I tried max or last aggregate functions but to no avail.

Help!.

Thank you.

Brigham


.

Relevant Pages

  • Re: Modeling Data for XML instead of SQL-DBMS
    ... then database theory becomes irrelevant. ... companies (rather than simply multiple people or processes), ... be accountable to the same management, or they could be accountable to ... under our control. ...
    (comp.databases.theory)
  • Re: Modeling Data for XML instead of SQL-DBMS
    ... then database theory becomes irrelevant. ... companies (rather than simply multiple people or processes), ... If the data and its model is all under YOUR control, ...
    (comp.databases.theory)
  • Re: Modeling Data for XML instead of SQL-DBMS
    ... then database theory becomes irrelevant. ... companies (rather than simply multiple people or processes), ... If the data and its model is all under YOUR control, ...
    (comp.databases.theory)
  • Re: companies selling reliable microcontrollers and sensors....
    ... second is www.Acroname.com for a wide range of sensors. ... we've been doing it about 10 year before Parallax got started at it. ... the Basic Stamp, are excellent for motion control, and particularly ... The Parallax Basic Stamp can only do one thing at a time. ...
    (comp.robotics.misc)
  • Re: Global datasets
    ... Sticking with the first method again. ... Populate my DataSet from the Database ... Create another control object instance ... re-instantiating it. ...
    (microsoft.public.dotnet.framework.aspnet)