[AccessD] query grouping problem

Hi Pedro

That's easy:

Select * From tblYourTable Where [Date]=#2010-02-02#

Or do we need some more info from you?

/gustav


>>> pedro at plex.nl 16-12-2010 11:57 >>>
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