Hi,

I want to bring up the following data for groups:
Blue, Red, Green and Yellow.

I have the following view in sql 7 which brings up the data i want,  How can
i bring up the data for the other groups within the same query.

SELECT DISTINCT
   salesorders.srep, SUM(salesitems.sprice) AS Expr1,
   delv.dtaxd
FROM dbo.salesorders INNER JOIN
   dbo.salesitems ON
   dbo.salesorders.son = dbo.salesitems.sona INNER JOIN
   dbo.delvitems ON
   dbo.salesorders.son = dbo.delvitems.dord AND
   dbo.salesitems.sonitem = dbo.delvitems.ditem INNER JOIN
   dbo.delv ON
   dbo.delvitems.delvnoa = dbo.delv.delvno
WHERE (dbo.salesorders.srep = 'blue') AND
   (dbo.delv.dedate > CONVERT(DATETIME,
   '2008-02-01 00:00:00', 102))
GROUP BY dbo.salesorders.srep, dbo.delv.dtaxd

I then need to call this query witin MS Access and use it to output to a
Data sheet.

Thanks

Mohammad