Help with a Date Query

[Ed75]

I need to select everything from a table between two dates but only need one result per person.

I can use SSN to identify an individual.

Help me out please, this is not something i'm used to..

Thanks

 

[DotNetGnat]

does this work for you?

Select SSN, Max(mydate)
from mytable
Where mydate between date1 and date2
group by SSN

-DNG

 

[Ed75]

That should work fine, thanks very much