[AccessD] group min - max

pedro at plex.nl pedro at plex.nl
Mon Dec 6 13:36:20 CST 2010


Dear list,

normally i use Group by and min max, to create a list of min or max (or first-last) dates per Patient. 

But when there is a third column which has different values, I'll make a key from date and patient-number and then ad the extra value.
How can i do this in one simple query?

I have

001    1-1-10    5
001    2-2-10    7
002    3-2-10    8
002    3-2-10    6

i need 

001    1-1-10    5
002    3-2-10    6

Thanks

Pedro



More information about the AccessD mailing list