[AccessD] query help

Pedro

SELECT Table1.Date, Table1.ax, Table1.ay, Table1.spec, Sum(Table1.mm) AS
SumOfmm, Sum(Table1.vv) AS SumOfvv, Sum(Table1.egg) AS SumOfegg,
Sum(Table1.Larf) AS SumOfLarf
FROM Table1
GROUP BY Table1.Date, Table1.ax, Table1.ay, Table1.spec;

This will give you the answer you ask for.  I cannot tell, though, whether
it is a solution to your underlying problem, since you don't say what that
is.

I didn't write the SQL, just got Access to generate it from the QBE grid,
which you can easily recover.

HTH
John


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen
Sent: 23 November 2008 10:29
To: AccessD
Subject: [AccessD] query help


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

 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com