[AccessD] query help

Pedro Janssen pedro at plex.nl
Sun Nov 23 04:28:44 CST 2008


Dear Group,

can you help me with a query?


I have:
 
Date                    ax               ay               spec             mm            vv             egg              Larf

01-01-01              123             123              A                  1                                             

01-01-01              123             123              A                                   3                             

01-01-01              123             123              A                                                  45            

01-01-01              345             345              A                  1                                             

02-02-02              678             678              B                                                  12            

02-02-02              678             678              B                                                                      4

 

 

i want

 

Date                    ax               ay               spec             mm            vv             egg              Larf

01-01-01              123             123              A                  1                3              45            

01-01-01              345             345              A                  1                                             

02-02-02              678             678              B                                                    12               4







How can i do this in a single query?



Thanks



Pedro

 



More information about the AccessD mailing list