[AccessD] query grouping problem

pedro at plex.nl pedro at plex.nl
Thu Dec 16 11:57:58 CST 2010


Dear List,

i have the following table:

ID    PatNr   Date          Name      code1       code2
1      01     1-1-2010      A           1          1
2      01     2-2-2010      B           1                       
3      01     2-2-2010      C                      1
4      02     5-1-2010      A                      1
5      02     5-1-2010      C                      1

I need:

2      01     2-2-2010      B            1                       
3      01     2-2-2010      C                      1


I tried several query's with groups on PatNr and Date, but i don't get it done.
Who can help me?

Thanks 

Pedro



More information about the AccessD mailing list